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. Quote 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 Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/164480-solved-backup-question/#findComment-867764 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.