Cetanu Posted July 2, 2009 Share Posted July 2, 2009 I downloaded a backup of my MySQL database, but dunno what to do now...I would like to use the backup to restore the database to its original state. Thanks. Link to comment https://forums.phpfreaks.com/topic/164480-solved-backup-question/ Share on other sites More sharing options...
BMurtagh Posted July 2, 2009 Share Posted July 2, 2009 Hey, If you have the mysqldump of the database you can restore it over the current database from command line. Once SSH'd on to the server use the following command: mysql -u [uname] -p[pass] [yourdatabase] < [backupfile.sql] This will restore the backupfile.sql to your database from command line. If you're using PHPMyAdmin follow these instructions at http://www.webcheatsheet.com/SQL/mysql_backup_restore.php#phpmyadmin Link to comment https://forums.phpfreaks.com/topic/164480-solved-backup-question/#findComment-867632 Share on other sites More sharing options...
Cetanu Posted July 2, 2009 Author Share Posted July 2, 2009 Okay, thanks. Link to comment https://forums.phpfreaks.com/topic/164480-solved-backup-question/#findComment-867764 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.