|
Answer
by: Stuart Pierce, Aplus.Net Knowledge Base Support.
Here
are step-by-step instructions on how to backup your MySQL database
through the phpMyAdmin interface. Please note that you can use
phpMyAdmin, only if you have a UNIX based shared hosting plan.
You
can login to phpMyAdmin using the Aplus.Net Control Panel:
- Start
by logging into the Aplus.Net Control Panel at http://cp.aplus.net
using your Registration Number and Customer Password.
- Select
Web Hosting from the top navigation bar.
- Next,
select Hosted Domains and click on Manage
Hosted Domains.
- Now,
select the hosted domain that you’d like to manage.
- Next,
click the MySQL Database Manager icon.
- Click
the manage database link associated with the exact
MySQL Database you’d like to backup.
Note:
You will be automatically redirected to the phpMyAdmin administration
tool.
- Select
your database name from the respective drop-down menu located in the
left-hand side of the page.
- Now,
Check all
tables
and click on Export in the top navigation bar.
- Again,
Select All tables; leave all other
settings as set by default.
- Then,
check the box next to Save
as file.
- Choose
the type of Compression you want and click Go.
- In
the newly opened dialog box select Save and choose
the location of the backup file on your computer.
To
import the backup file to your MySQL database using phpMyAdmin, go to
the SQL query window and simply browse to the file
on your computer.
Related
links:
|
post your comment
print
send to a friend
Browse the Base
