Board index   FAQ   Search  
Register  Login
Board index php forum :: Database phpMyAdmin

How to Export All Tables?

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: macek, egami, gesf

How to Export All Tables?

Postby acellec » Mon May 21, 2012 11:10 pm

I have 352 tables how can i export all these tables and import it? It seems that it doesn't export all tables.
acellec
New php-forum User
New php-forum User
 
Posts: 26
Joined: Thu May 17, 2012 5:44 pm

Re: How to Export All Tables?

Postby egami » Tue May 22, 2012 4:07 am

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
User avatar
egami
php-forum GURU
php-forum GURU
 
Posts: 2197
Joined: Wed Oct 06, 2010 11:19 am
Location: Happy Valley, UT

Re: How to Export All Tables?

Postby acellec » Tue May 22, 2012 4:11 pm

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?
acellec
New php-forum User
New php-forum User
 
Posts: 26
Joined: Thu May 17, 2012 5:44 pm

Re: How to Export All Tables?

Postby Nullsig » Wed May 23, 2012 7:50 am

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.
User avatar
Nullsig
php-forum Fan User
php-forum Fan User
 
Posts: 981
Joined: Thu Feb 17, 2011 6:52 am
Location: Racine, WI


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron