|
Backing Up Your Database
There are two main ways to back up or restore a MySQL database on our servers: via SSH Telnet access or the Database Manager (also called phpMyAdmin) interface.
If you need SSH Telnet access, just send us a ticket with your request to be enabled for it, and if you'd like more information about how to connect to our servers with it, just visit our SSH Telnet support page. To access the phpMyAdmin interface, click on the "mySQL" button on your One World Hosting control panel.
How to back up a mySQL database using SSH Telnet:
Log into your account on our server and issue the following command:
[This is all one command line!]
/usr/local/mysql/bin/mysqldump $databasename -u $user -p$password > /home/$user/file.dump
$ indicates a variable, so instead of entering $user, you'll enter your actual user name for your account. Your mySQL username and password are usually the same as the ones that you use to access your control panel.
For example, your actual command might look like this:
/usr/local/mysql/bin/mysqldump joescars_com -u frankie -p18circ > /home/joe/joesbackup.sql
How to restore a mySQL database using SSH Telnet:
Log into your account on our server and issue the following command:
[This is all one command line!]
/usr/local/mysql/bin/mysql $databasename -u $user -p$password < /home/$user/file.dump
How to back up a mySQL database using the Database Manager:
Click on the "MySQL Database" button on your hosting account Control Panel, then click on the link that corresponds to the database that you want to back up. Click on the "Manage Database" button.
Click on the database name on the top left column, and click on the "Export" tab at the top. Then choose options for back up structure, data, and file format. To view what your backup file will look like, leave the "Save as file" check box unchecked and click on the "Go" button. When you're ready to send your back up to a file, check the box, choose your file name, and click "Go", then follow the prompts for where to save it on your local computer.
How to restore a mySQL database using phpMyAdmin:
Click on the "MySQL Database" button on your hosting account Control Panel, then click on the link that corresponds to the database that you want to restore. Click on the "Manage Database" button.
Click on the "Query Window" link on the upper right, above the list of tables. A new window will open - click on the "Import files" tab at the top. Choose the appropriate radio button for your file type, then click the "Browse" button to locate your file, and click the "Go" button.
Installing a MySQL Database
Using PHP and MySQL
ODBC, or Using an Access Database
|
0