where is mysql database store?

[seachen]

let said my database is abc_xyz

how to copy the file abc_xyz.sql ?

where it located?

 

[scsi]

Its located no where. Use phpmyadmin to get a backup of your database. Go to export tab and select the database you wish to backup.

 

[floyd]

how to copy the file abc_xyz.sql ?

where it located?

That is not the database. That is a database dump which contains all the data and all the commands to restore the database. You won't find it unless you create it.

 

[markhard]

mysql databases is usually stored in /var/lib/mysql

if you want to make a backup it's better to use phpmyadmin to dump the sql file

 

[scsi]

No need to repeat the same thing over and over..thanks.

 

[floyd]

No need to repeat the same thing over and over..thanks.

Sometimes it is helpful if the same thing is phrased slightly differently.

 

[sde]

Sometimes it is helpful if the same thing is phrased a bit differently.