Connecting to MySql at local machine

[Anon]

Need help!!!!
Actually I am trying to extract data from database at my site and want to store it in a table at my local machine.

Can somebody help me with exact procedure!!!

[nguip]

🙂 I'm looking for this solution as well.. Also, I would like to know the exact procedure to export my database from local machine to my remote web-server.

Any help is very much appreciated !

[Anon]

export: mysqldump [dbname] filename

and

import: mysql [dbname] < filename

[Anon]

Thanks,

Actually that worked to get the backup of database. If anything can be tried using PHP so that script abstacrts the data from remote server and store it in a table at local server.

at wrote:

export: mysqldump [dbname] filename

and

import: mysql [dbname] < filename