BoxSlots.com - Unmetered 100Mbit/1Gbit/2Gbit VPS from ?10.99/month (Netherlands)

[rohan123]

thank you, after i do that i can save the file somewhere else. what do i do if i want to restore from a backup?

for restoring use this

mysql -u user -p dbname < {path}/backup.sql

replace the user with the user of where u want to restore the db

replace dbname with the dbname u have created where u want to restore

replace path with the path of the database backup file (.sql file) ( u need to put it into ur server )

----

so if u have created new user in cpanel named "michael" and created a db with name "michael_db" and put the backup file in ur site's root and ur backup file's name is backup.sql then u will use this command..

mysql -u michael -p michael_db < /home/michael/public_html/backup.sql

rohan123 Reviewed by rohan123 on 5th Dec 2011. BoxSlots.com - Unmetered 100Mbit/1Gbit/2Gbit VPS from ?10.99/month (Netherlands) http://i.imgur.com/mWPwH.png Who are we? BoxSlots Ltd is a fully registered UK company formed in November 2010, since that time we have provided our services to hundreds of clients from over 60 different countries worldwide. We take pride in our first class support and are always happy to assist our customers. Payment Methods Rating: 5