Moving MySQL databases & other files

echo · November 14th, 2004, 8:00 PM

This is (I believe) only the first time I've switched hosts for echoes.nu. I am completely clueless as to how I can save my MySQL databases (and any other related files) and move them over to Surpass.
If anyone can offer advice, I'd be very grateful

I guess I should give you guys a little more info to work with

HostRocket is the company that I'm moving from; my control panel over there looks very similar to their demo panel.

I downloaded the daily backup of my site via the link provided, but that's about as far as I got. Would the daily backup include database info? And when I opened the backup archive I had no idea what some of those files are and what to do with them.

I feel like such a moron! Please help me out

Thanks!!!

**Ehaanaes** · November 14th, 2004, 8:03 PM

Try to use phpMyAdmin to make a backup?
And i guess the daily backup should include database info.
Try to mail support[at]surpasshosting.com and ask them. Maybe they can help.

And please do not feel like a moron.. Had the same problem when i moved for the first time.. (To surpass.

) They helped me out..

echo · November 14th, 2004, 8:16 PM

Thank you very much

Technicae · November 14th, 2004, 10:40 PM

phpMyAdmin's 'import' feature is mostly worthless, in my experience. I've never had it actually work, and the filesize ceiling is only 50MB. See if you can download the databases in some compressed form, then upload it to your home dir (the one above public_html), then make the database you want it to be extracted to, then ask support very nicely and they can extract it there for you.

I think you can use phpMyAdmin's 'export' feature to create a gzipped file, or even just a .sql

Hope this helps

**sam** · November 14th, 2004, 11:23 PM

Technicae - the import feature does work, but as you say there is a limit.

The restore db from cpanel > backup also works nicely.

echo - keep in mind if the need arises ( say the database is massive ) to contact support to load the database from your home directory it's considered a low priority task. it will get done, support is happy to do it, but technical issues come first.

TerraFrost · November 14th, 2004, 11:27 PM

a php script to make a backup...

Code:

<?
  exec("mysqldump --opt -u $dbuser --password=$dbpasswd --host=$dbhost $dbname | gzip > $dbname.gz");
?>

and a php script to restore a backup:

Code:

<?
  exec("gunzip < $dbname.gz | mysql -u $dbuser --password=$dbpasswd --host=$dbhost $dbname");
?>

the variables should be self-explanatory, save for, perhapes the $dbhost one. that one should be set to localhost in the first script and set to the name of the new host in the second script.

**sam** · November 14th, 2004, 11:30 PM

hi terrafrost - we have something similar to that...

could you tack your above post onto this thread here?
Want to Backup your MySQL databases automagically?

TerraFrost · November 14th, 2004, 11:42 PM

Quote:

Originally Posted by sam

could you tack your above post onto this thread here?
Want to Backup your MySQL databases automagically?

done

echo · November 15th, 2004, 2:42 PM

Fellow Surpassers ROCK!! (as does Surpass)

I'm going to follow your directions (later on tonight - I have to go out for a bit) and will report back with the results.

Thanks you guys

November 14th, 2004, 8:00 PM	#1 (permalink)
echo Registered User Seasoned Poster Joined in Nov 2004 Lives in The Crazy Diamond Mine Hosted on Pass17 40 posts Gave thanks: 5 Thanked 0 times	Moving MySQL databases & other files This is (I believe) only the first time I've switched hosts for echoes.nu. I am completely clueless as to how I can save my MySQL databases (and any other related files) and move them over to Surpass. If anyone can offer advice, I'd be very grateful I guess I should give you guys a little more info to work with HostRocket is the company that I'm moving from; my control panel over there looks very similar to their demo panel. I downloaded the daily backup of my site via the link provided, but that's about as far as I got. Would the daily backup include database info? And when I opened the backup archive I had no idea what some of those files are and what to do with them. I feel like such a moron! Please help me out Thanks!!! __________________ I exist here. I must learn to walk in this world. Pass17 echoing.org Bronze Reseller

November 14th, 2004, 8:03 PM	#2 (permalink)
Ehaanaes Forum Moderator Super #1 Joined in Aug 2003 Lives in Norway Hosted on Minerva 1,215 posts Gave thanks: 0 Thanked 0 times	Try to use phpMyAdmin to make a backup? And i guess the daily backup should include database info. Try to mail support[at]surpasshosting.com and ask them. Maybe they can help. And please do not feel like a moron.. Had the same problem when i moved for the first time.. (To surpass. ) They helped me out.. __________________ Owner of Minerva and Server :: Beatiful P4's Surpass http://www.case-spider.com Winner of the Surpassies 2004 - Most Spirit. :bravo: Google = Friend!

November 14th, 2004, 8:16 PM	#3 (permalink)
echo Registered User Seasoned Poster Joined in Nov 2004 Lives in The Crazy Diamond Mine Hosted on Pass17 40 posts Gave thanks: 5 Thanked 0 times	Thank you very much __________________ I exist here. I must learn to walk in this world. Pass17 echoing.org Bronze Reseller

November 14th, 2004, 10:40 PM	#4 (permalink)
Technicae Registered User Seasoned Poster Joined in Sep 2004 54 posts Gave thanks: 0 Thanked 0 times	phpMyAdmin's 'import' feature is mostly worthless, in my experience. I've never had it actually work, and the filesize ceiling is only 50MB. See if you can download the databases in some compressed form, then upload it to your home dir (the one above public_html), then make the database you want it to be extracted to, then ask support very nicely and they can extract it there for you. I think you can use phpMyAdmin's 'export' feature to create a gzipped file, or even just a .sql Hope this helps __________________ http://www.technicae.net on Ultra

November 14th, 2004, 11:27 PM	#6 (permalink)
TerraFrost Registered User Seasoned Poster Joined in Nov 2004 45 posts Gave thanks: 0 Thanked 0 times	a php script to make a backup... Code: <? exec("mysqldump --opt -u $dbuser --password=$dbpasswd --host=$dbhost $dbname \| gzip > $dbname.gz"); ?> and a php script to restore a backup: Code: <? exec("gunzip < $dbname.gz \| mysql -u $dbuser --password=$dbpasswd --host=$dbhost $dbname"); ?> the variables should be self-explanatory, save for, perhapes the $dbhost one. that one should be set to localhost in the first script and set to the name of the new host in the second script. __________________

November 14th, 2004, 11:23 PM	#5 (permalink)
sam Surpass Fan Super #1 Joined in Dec 2003 Lives in NJ 5,057 posts Gave thanks: 0 Thanked 4 times	Technicae - the import feature does work, but as you say there is a limit. The restore db from cpanel > backup also works nicely. echo - keep in mind if the need arises ( say the database is massive ) to contact support to load the database from your home directory it's considered a low priority task. it will get done, support is happy to do it, but technical issues come first.

November 14th, 2004, 11:30 PM	#7 (permalink)
sam Surpass Fan Super #1 Joined in Dec 2003 Lives in NJ 5,057 posts Gave thanks: 0 Thanked 4 times	hi terrafrost - we have something similar to that... could you tack your above post onto this thread here? Want to Backup your MySQL databases automagically?

November 15th, 2004, 2:42 PM	#9 (permalink)
echo Registered User Seasoned Poster Joined in Nov 2004 Lives in The Crazy Diamond Mine Hosted on Pass17 40 posts Gave thanks: 5 Thanked 0 times	Fellow Surpassers ROCK!! (as does Surpass) I'm going to follow your directions (later on tonight - I have to go out for a bit) and will report back with the results. Thanks you guys __________________ I exist here. I must learn to walk in this world. Pass17 echoing.org Bronze Reseller

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search