How to Backup MySQL Database

[honeycomb 0]

in mysql install directory:\mysql\bin>mysqldump -u root -p root your_DB_name > back.sql

[dissipate 0]

i think i should point out that the bin directory is where you installed mysql, whatever comes after -u is your username and whatever comes after -p is your password.also, most people typemysqldump -u root -p your_DB_name > back.sqlso that their passwords will not be shown as clear text on the screen.

[lipunuska1405241470 0]

Thanks for that tutorial, I really needs to backup some databases, but whow I can do that?

[honeycomb 0]

Thanks for that tutorial, I really needs to backup some databases, but whow I can do that?

<{POST_SNAPBACK}>

ok, in your OS(unix/linux) system, change directory to \mysql\bin, in this directory, type mysqldump -u root -p root your_DB_name > back.sql , then press enter, root is your DB name and password,

your_DB_name is the DB you want to backup,

back.sql is the file name you want to backup to.

now do you understand?

[deivid1405241470 0]

if you have phpmyadmin installed you can also do this.

 

first go to phpmyadmin

 

 

click in export

 

you will see something like this

 

 

select the database that you want to export, check save to file, and choose a name and you have the database.sql file

[bx93 0]

When I used the export function, there was some trouble when the content was displaying on the page:The IE explorer crash.I wonder if the type longtext cause the problem. (there is some field larger than 40K byte)

[deivid1405241470 0]

uhhmmm very strange, i always backup the database in that way, do you try another browser, maybe you ie has something wrong (configuration, spyware, etc.). Try use firefox, opera or netscape.Greets Deivid

[bx93 0]

uhhmmm very strange, i always backup the database in that way, do you try another browser, maybe you ie has something wrong (configuration, spyware, etc.). Try use firefox, opera or netscape.
Greets Deivid

Thanks deivid, Firefox works. no crash showed.
Seems Firefox is even more faster than IE. Though it's cost me quite a while to download it, I hope it will save me more time from now on. However, my wife is not family with English, so I still keep the IE6(Chinese version) for her. Is there any Chinese version for Firefox or such things?

[deivid1405241470 0]

Seems Firefox is even more faster than IE

no firefox it's faster and better and exists for all people, check this sites:

Chinese Simplified China Firefox 0.8

Chinese Traditional Taiwan Version 1.0 PR

Greets Deivid

[bx93 0]

no firefox it's faster and better  and exists for all people, check this sites:

 

Chinese Simplified China Firefox 0.8

 

Chinese Traditional Taiwan Version 1.0 PR

 

Greets Deivid

<{POST_SNAPBACK}>

Got it, thanks deivid. However, there is some problem with firefox, which I met these two days:

1) Its display is not always same as IE6. There is a little difference in my site: http://forums.xisto.com/no_longer_exists/

2) The search result is not same as IE6. using google to search some Chinese words, but got lots of Japanese web pages. Hope the Chinese version could help me with this.

[sha1405241471 0]

you can easily back up my sql using backup facility. but i never recomond it..because if your site fails the front end get destroyed and there is no use by just restoring the data base. so always use full site backup n store the back up in another server(NOT ON THE SERVER U R HOSTING).

[vietpost 0]

Okie, we have no problems exporting MySQL databases from PHPMyadmin, but I have another problem. If my database size is too big, how can I export that bulk file with the browser? My recent database for our community is 43 MB, It may takes me a day to export this database with 56K line.Do you have any other ways to do work this out?

[bx93 0]

Okie, we have no problems exporting MySQL databases from PHPMyadmin, but I have another problem. If my database size is too big, how can I export that bulk file with the browser? My recent database for our community is 43 MB, It may takes me a day to export this database with 56K line.

 

Do you have any other ways to do work this out?

There is some introduction for database backup,

 

mysqldump

http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html

 

mysqlhotcopy

http://dev.mysql.com/doc/refman/5.6/en/mysqlhotcopy.html

 

I don't know if mysqlhotcopy can be run here, otherwise it will save you much time.

 

I have just posted a suggestion on backup which focus on delta http://forums.xisto.com/topic/80277-topic/?findpost=1064276331 , hope that will be helpful to you also.

[spotok 0]

hi, i wonder is there no technique to backup mysql database whose size exceeds 51200KB ? i am not the root. my database is of 114688KB with about 2600 files in it. somebody suggest me an idea please. if it crashes i have to upload all files again..!

[Stude 0]

Thanks. This is tutorial what I really needed