Total members 11890 |It is currently Wed Apr 24, 2024 4:10 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





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:
File comment: export database in mysql
export database.GIF
export database.GIF [ 32.75 KiB | Viewed 10068 times ]

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada
Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 1 post ] 

  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 host information in php     -  
 DYNAMIC DATES IN MYSQL     -  



cron





Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com