Windows A backup of large database?

[kito2]

For people who works with windows, it seems impossible to make a 100% working backup of the database...

When you try to export the database, it just save some lines but there are missing lots of them...

This really sux...

Someone knows how to solve this problem?

 

[zakius]

on windows you can... copy whole mysql directory(for some reason copy of only data dir doesnt work xD)

 

[richux]

Idk if this will work, but try start->run->cmd

mysqldump -uroot -ppassword dbname > \C:\backup.sql

not sure if I declared path correctly, u can also try:

/C:/backup.sql

or

C:/backup.sql

etc.

 

[EvulMastah]

not sure if I declared path correctly, u can also try:

C:/backup.sql

this, but \

 

[Diath]

Idk if this will work, but try start->run->cmd

mysqldump -uroot -ppassword dbname > \C:\backup.sql

not sure if I declared path correctly, u can also try:

/C:/backup.sql

or

C:/backup.sql

etc.

Make a shortcut of mysql dump, then -uroot -ppassword dbname > C:\backup.sql in command line.

 

[SpiderOT]

from the xampp control panel click on shell and it will open something like cmd screen
type this

mysqldump -u root -password databasename> databasename.sql

and you will find the backup file in xampp folder

 

[kito2]

Damn, I can't do the ">", Im on a notebook.
Also, when I try to type this command on CMD, it says that mysqldump doesnt exist :S

Spider, Im checking your guide, Im going to test it.

 

[Cykotitan]

Also, when I try to type this command on CMD, it says that mysqldump doesnt exist :S

cd C:\xampp\mysql\bin

 

[kito2]

I used: http://otland.net/f258/tutorial-backup-database-screenshots-40795/ - It works great!