[RESOLVED] How to get uptodate data in phpMyAdmin?

[rosy]

Hi,
I have an development server and data in phpMyAdmin similar to production(MySql). Its been four months and its not yet updated.
How i can get the uptodate data from the production database(MySql) to development database (phpMyAdmin)?
Please help me on that and give me some step by step information , how i can make it.
Thanks.

[gotissues68]

If you have command line access to both servers you could just dump the data from the production server to the development server.

On the prod server you'd run:
mysqldump -u <your username> -p <your password> database <tables> > <your backup file>

and then on dev server

mysql -u <your user> -p <your pass> database < <backup file>

and you should be good to go.

[rosy]

Hi,
I have the command line access in both the server,
In the above line on production server,
database <tables> > <your backup file>
do i need to give the name of the database in database?
How do i need to backup the file ?
please help as i am new to it.
Thanks.

[gotissues68]

right you'd give it the name of the database and then any tables within the database otherwise it'll dump the whole thing. Here's an example with the name of a database I have

mysqldump -u drew -p contentmanagement > backup.sql

[rosy]

Thanks very much and its working for me :-).

[gotissues68]

Awesome! Glad I can give back :-)