How do i backup my mysql database?

Is that all i need to do to backup my whole site??plz help. thx.

 

You should use phhmyadmin to backup your database.

If you need help with that reply.

 

cpanel -> back ups

 

You can also use the EXPORT feature within phpadmin. That will dump the tables and data. Not a bad idea to do this at least once so you can rebuilt it if necessary.

David

 

Can u please explain step by step? It would be appreciated thx. kinda a newb

 

If you have cPanel the easiest way to do this is to hit the backups icon. Once you get to that page it is self explanatory and very simple to do.

 

sorry I know may seem stupid but i don't know how to access cpanel

my host is 1and1

 

If you dont know how to access cPanel then your host probably does not provide it. cPanel is a website control panel where you access your files. If you have it you will access it at

yourwebsiteurl/cpanel/

 

You don't have a cPanel. You have an abomination known as the half and half control panel.

If you have phpmyadmin, I will try to post a step by step for you.

Please post back or PM me.

 

use phpmyadmin to backup database or sqlyog desktop application for database backup

 

i have phpmyadmin, plz post step by step. thx.

 

How to Backup a MySQL Database in phpMyAdmin

1. Open phpMyAdmin.
2. Login.
3. Select the database on the right-hand menu that you wish to backup.
4. On the menu listed at the top of the page, select "Export".
5. Scroll down to the bottom of the page.
6. Click on the tick box next to "Save as file".
7. Click "Go".

How to Restore a Database in phpMyAdmin

1. Create a database.
2. Open phpMyAdmin.
3. Login.
4. Select the database on the right-hand menu that you wish to restore the old dump to.
5. On the menu listed at the top of the page, select "Import".
6. Click "Browse..." and locate the dump on your computer.
8. Click "Go".

 

Charles has pretty much posted the correct steps.

I usually save the file as a zip file. That is just a box you check.

 

I will try this over the weekend. Thx for caring enough to post step by step instructions. You have been a great help!

 

Any luck?

 

well there are couple of ways u can do tht, if u have SSH access and you want to backup your site enter this command in SSH

/scripts/pkgacct siteusername

the above script will create a zip file of ur whole site.

and secondly if u want to backup your database enter this command in SSH

mysqldump -udbusername -pdbpassword --dbname >filename.sql

If you don't have SSH access then all of the above information is of no benefit, better would be to ask your web host to create a backup of your site.

 

the best way to setup a backup for a mysql db is through cronjob using the mysqldump command.
you can even set it up to run daily, it's up to you.