Page 1 of 1

How to Export All Tables?

Posted: Mon May 21, 2012 11:10 pm
by acellec
I have 352 tables how can i export all these tables and import it? It seems that it doesn't export all tables.

Re: How to Export All Tables?

Posted: Tue May 22, 2012 4:07 am
by egami
I'm not sure about PHPmyAdmin, but you can do the whole thing in one smooth swoop through your shell account.


mysql -pPassword {databasename} > filename.ext

Re: How to Export All Tables?

Posted: Tue May 22, 2012 4:11 pm
by acellec
egami wrote:I'm not sure about PHPmyAdmin, but you can do the whole thing in one smooth swoop through your shell account.


mysql -pPassword {databasename} > filename.ext
what do you mean shell account?

Re: How to Export All Tables?

Posted: Wed May 23, 2012 7:50 am
by Nullsig
He means that you have to log into your server command line (via SSH) and enter the command.

You could also use PHPMyAdmin. Just select the database then click export and choose ALL of the tables.

Re: How to Export All Tables?

Posted: Wed Apr 30, 2014 11:18 pm
by gauravkachhadiya
you will click on database name then click on export it wil export full database and import database it will import all the tables in one time..