WatsonN Posted November 4, 2010 Share Posted November 4, 2010 I'm looking for a way to download all the database information and upload it to a totally diffrent server. Is this possible? If so, where should I start. Thanks in advanced. Quote Link to comment https://forums.phpfreaks.com/topic/217784-php-and-mysql-backuprestore/ Share on other sites More sharing options...
01hanstu Posted November 4, 2010 Share Posted November 4, 2010 Hi, It may be worth installing the MySQL GUI Tools on your machine, and open it up and input the hostname as the old server--> Backup the database, then connect to the new server, changing the hostname, Restore the database. Hope it helps, Stu Quote Link to comment https://forums.phpfreaks.com/topic/217784-php-and-mysql-backuprestore/#findComment-1130425 Share on other sites More sharing options...
WatsonN Posted November 4, 2010 Author Share Posted November 4, 2010 I'll Check it out Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/217784-php-and-mysql-backuprestore/#findComment-1130426 Share on other sites More sharing options...
BlueSkyIS Posted November 4, 2010 Share Posted November 4, 2010 or phpMyAdmin Quote Link to comment https://forums.phpfreaks.com/topic/217784-php-and-mysql-backuprestore/#findComment-1130429 Share on other sites More sharing options...
WatsonN Posted November 4, 2010 Author Share Posted November 4, 2010 or phpMyAdmin I already use that, I was just seeing if there was an automated way i could write into a script. Quote Link to comment https://forums.phpfreaks.com/topic/217784-php-and-mysql-backuprestore/#findComment-1130438 Share on other sites More sharing options...
tHud Posted November 5, 2010 Share Posted November 5, 2010 Maybe something like this? http://silisoftware.com/scripts/?scriptname=backupDB Quote Link to comment https://forums.phpfreaks.com/topic/217784-php-and-mysql-backuprestore/#findComment-1130753 Share on other sites More sharing options...
WatsonN Posted November 5, 2010 Author Share Posted November 5, 2010 @tHud That is, Thank you. So when I want to upload that information into a new database would i just put the sql file in a mysql_query()? Quote Link to comment https://forums.phpfreaks.com/topic/217784-php-and-mysql-backuprestore/#findComment-1130866 Share on other sites More sharing options...
trq Posted November 5, 2010 Share Posted November 5, 2010 No, you would use the command line: Make a dump: mysqldump -p dbname > dump.sql Import to another database server (empty db needs to exist first) mysql -p dbname < dump.sql Quote Link to comment https://forums.phpfreaks.com/topic/217784-php-and-mysql-backuprestore/#findComment-1130870 Share on other sites More sharing options...
WatsonN Posted November 5, 2010 Author Share Posted November 5, 2010 Thank you thorpe. That is exactly what I needed to know. Quote Link to comment https://forums.phpfreaks.com/topic/217784-php-and-mysql-backuprestore/#findComment-1130873 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.