|
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 -h $domainname.com
$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 -h joesjoescars_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.
Back to Control Panel Details
|
Account Control Panel
SITE SEARCH:
Control Panel 