How To Import a MySql Database

 *NOTES*: You may have to replace quotation marks entry with fresh keystrokes. Also be sure the database you are importing matches the software version you are importing into. Many errors happen from people updating and trying to import older databases.

HOW TO IMPORT MYSQL PHPBB DATABASE
(Go to SSH command screen)
(Entre location of folder with DB)

cd /home/sites/domainname/www/
(this is home directory for site on server)

MANUALLY GO TO PHPMYADMIN AND DROP DB

NOW, RECREATE SAME DATABASE NAME

(Import the backup)
mysql -u root -ppassword “dbname” < dbname.sql > /dev/null

Leave a Reply

Your email address will not be published. Required fields are marked *