Exporting tables from one to another [help req]

[xtone]

hi i wanna export my table called dle_post >>> it includes all my post and table called dle_user as it has all my users in it so how can i do that in mysql i am on shared hosting using cpanel >>> phpmyadmin to do that please guide me !

i am using DLE 9.3 by the way need help guys

xtone Reviewed by xtone on 27th Sep 2011. Exporting tables from one to another [help req] hi i wanna export my table called dle_post >>> it includes all my post and table called dle_user as it has all my users in it so how can i do that in mysql i am on shared hosting using cpanel >>> phpmyadmin to do that please guide me ! i am using DLE 9.3 by the way need help guys Rating: 5

[Loonycgb2]

go into phpmyadmin...
Click on the database you need to do it in...
The there will be a tab on the top that says export...
Chose the two tables you want exported and export the sql file

[xtone]

unfortunately i cant upload (export) my old db it gives me an error i dont know y !

i do got my old db in my pc but i tried twice to upload into my 2nd db so that i can import it into my new db but it gives me error

[rareyush]

download your database from cpanel instead of phpmyadmin

and use bigdumo.php file to import db if size of ur database is high/

[Sonic]

enter to phpmyadmin
select the table you want to export
at the drop-down menu below select export
download the table

[S?nic]

...

I have an impersonator?

[Loonycgb2]

it might be trying to create the database which in phpmyadmin you dont have permission too do that...

Just go into your database and press the sql tab and a text box should show...

Now edit your sql file (the one with only the 2 tables) in a notepad and copy the entire thing and paste it in the textbox.. and make sure to remove anything that says create database.. it should only be create table