How i Can Make Sql backup

[Himad]

hello.

Iam moving into new dedicated server so i wonder if it possible
to make sql backup to prevent char reset
iam using mysql

Rep++

Thanks In advance
/HImad

 

[ond]

Export the database and save it as MySQL.

 

[zyirc]

Or go to Disk C:/Xampp/mysql/data then look for your database name and copy the whole folder to example: Desktop then you have the whole database.

 

[ond]

Isn't that uneccary if he just wants to make a backup?

Or perhaps it's the same

 

[Grehy]

Or go to Disk C:/Xampp/mysql/data then look for your database name and copy the whole folder to example: Desktop then you have the whole database.

NEVER do that, it will not work unless you have the same mysql version, and it can cause damage if you don't.

You need to dump your db and import it on the new computer

 

[ExibeR]

NEVER do that, it will not work unless you have the same mysql version, and it can cause damage if you don't.

You need to dump your db and import it on the new computer

^ = Correct

Log into your database (http://localhost/phpmyadmin/)
Then click on your database, then check [Save] at the bottom, and save it on your computer.

Then you transfer this file to your new computer, and just import it like you did with the "schema.mysql" when creating the server.

 

[Specjalist]

Never use phpmyadmin to export your database...

I don't know how it exactly works on Windows but it might be like that:

mysqldump -u<username> -p<password> database_name > /path/to/filename.sql

of course from the command line