Originally posted by acctman i used the shell command. "mysqldump -u USER -p PASS --databases chatdb mabrater pforms phpqjr phpquest > multibackup.sql " how do I restore the the databases to another site location?
To restore the back up
#mysql -u<USERNAME> -p
mysql -u dbusername -p databasename < /path/to/backupname.sql
If MySQL is a on seperate server use:
mysql -h servername -u dbusername -p databasename < /path/to/backupname.sql
MediaLayer, LLC - www.medialayer.comLearn how we can make your website load faster, translating to better conversion rates for your business!
The pioneers of optimized web hosting, featuring LiteSpeed Web Server & SSD Storage - Celebrating 10 Years in Business
You've essentially told mysql to throw all your databases into one huge databse. Are you sure that's what you want? Most often, it's not.
The way to solve this:
Edit the sql file , split it up into the original databases, then follow the instructions given to restore the files on the new server, OR simply do a backup the proper way (backup each db separately into it's own file) if you still have access to the server
WHMCS Guru - WHMCS addons, management, support and more. WHMCS Notifications Extended - Add slack, hipchat, SMS, pushover to WHMCS !!
Linux Problems? WHMCS Issues? +1-866-546-8914 (linux-14) or @whmcsguru on twitter!