Hosting and moving a MySQL database...Update: Question about reseller accounts

[conjur]

Anyone ever done that?

If so, feel free to comment

 

[StageLeft]

yer link is dead!

 

[Entity]

Oooh. Cross-posting. In different forums no less.

Moving a MySQL database is really simple. How are you getting the mysql dump? From the commandline or through the Invisionboard admin interface?

Rob

 

[AgaBoogaBoo]

Do you have access to the files MySQL created?

 

[conjur]

Originally posted by: Entity
Oooh. Cross-posting. In different forums no less.

Moving a MySQL database is really simple. How are you getting the mysql dump? From the commandline or through the Invisionboard admin interface?

Rob

I can do it either way...I can export from the phpMyAdmin screen and export in .CSV or SQL mode (with complete inserts or extended inserts and can include DROP DATABASE) or I can do the host-specified backup.

 

[mugs]

Originally posted by: conjur

Originally posted by: Entity
Oooh. Cross-posting. In different forums no less.

Moving a MySQL database is really simple. How are you getting the mysql dump? From the commandline or through the Invisionboard admin interface?

Rob

I can do it either way...I can export from the phpMyAdmin screen and export in .CSV or SQL mode (with complete inserts or extended inserts and can include DROP DATABASE) or I can do the host-specified backup.

You apparantly know what you're doing... so what do you want comments on?

 

[conjur]

Well, I can do the Export but it's the restoring I'm unsure of.

 

[Rias]

How about just using mysqldump? That way you will be able to import it into a new database.

mysqldump ..options.. database > db.sql
and then just import it on the new database with
mysql ..options.. < db.sql

Is it just me or is yagt.org not working?

 

[Entity]

Originally posted by: conjur
Well, I can do the Export but it's the restoring I'm unsure of.

It's really easy. If you export it as a SQL file, you just do something from the commandline like:

mysql -u USERNAME -p PASSWORD DATABASENAME < filename.sql

Rob

 

[conjur]

Is that done from, say, a telnet session or something?

<--- telnet/unix n00b

 

[Entity]

Originally posted by: conjur
Is that done from, say, a telnet session or something?

<--- telnet/unix n00b

From commandline, yes (SSH in).

Rob

 

[mugs]

Originally posted by: conjur
Well, I can do the Export but it's the restoring I'm unsure of.

You can do that through PHPmyadmin - the query box gives you the option of selecting a file to read the SQL commands from (definitely set it up on the new server before killing the database on the old one though)

 

[EyeMWing]

Telnet? BLASPHEMY! Use SSH.

 

[conjur]

Trying it thru the phpMyAdmin...Run SQL option...we'll see.

Finally got off the phone...

 

[mugs]

Did it work?

 

[conjur]

I think it's going now...trying to upload like 13.5MB at 128kbps...gonna take a while


<--- off to grab a :beer: (Guinness)

 

[minendo]

The import into InvisionBoard sucks.

 

[conjur]

Crap...no shell access on the acct...says I need to contact support.

And, the import is timing out after 5 mins. Gonna try something else.

 

[mugs]

Do it piece by piece - there's a limit to the size of files you can upload to the webserver via http (depends on the server - you could set up a script that calls phpinfo() to find out what the size limit is on your server, but it's probably about 2 MB).

 

[conjur]

yeah...that's the next step

 

[mugs]

Also, since you're apparantly moving forums, make sure you copy all of the custom avatars and skins and whatnot to the new server

 

[RossMAN]

Originally posted by: mugsywwiii
Also, since you're apparantly moving forums, make sure you copy all of the custom avatars and skins and whatnot to the new server

Correct and I can help you conjur with that, do you have AIM or MSN?

Do you have SSH access on your thrillhost account?

 

[iwearnosox]

gzip and wget are your friends, you can transfer it in a couple of minutes.

 

[conjur]

Got the MySQL moved over...then I realized I'd moved it to conjur.com and not yagt.org.

DOH!

5-10 more mins. and I'll have MySQL data moved to the PROPER location. Then I just have to restore the yagt directory structure.


RossMAN, I don't have AIM nor MSN Messenger...just Yahoo.

 

[mugs]

As long as you restore the directory structure exactly the way it was, you'll be set.