Switch to full style
Tutorials, source code, tips and tricks related to mysql
Post a reply

dump Mysql database

Fri Apr 06, 2007 1:12 pm

If you want to dump your database you have two solutions :

1. From the console :

enter the following under /bin/ directory inside the Mysql server in the constol

mysqldump -u root -p mile > data.sql
"root" is the username
"mile" is the database
"data.sql" is the dump



2. From PhpmyAdmin :
if you have phpAdmin i will be much easier to dump your database using the Graphical user interface of the phpAdmin. in few seconds your dump we be exits.
Do the following
1. Choose database
2. Press export tag.
3. press ok.
:D finish

:idea: Remember you can customize your dump for example you can put automatically in zip. file.


Attachments
export database.GIF
export database in mysql

Post a reply
  Related Posts  to : dump Mysql database
 How to import your website dump database script     -  
 import Mysql database     -  
 Creating a Database in MySQL     -  
 Optimize All Tables In A MySQL Database     -  
 IP Address Lookup in Bulk Using C-Sharp and MySQL Database     -  
 need help in mysql     -  
 connect to MYSQL from ASP     -  
 need help in jdbc with mysql     -  
 MySQL server information getting in php     -  
 establish a connection with MySQL in php     -