Jump to content


Photo

Copy tables to another db


  • Please log in to reply
3 replies to this topic

#1 chriss

chriss
  • Members
  • PipPip
  • Member
  • 10 posts
  • LocationZG, Poland

Posted 03 October 2003 - 10:01 AM

How to copy all tables (with all data) from one db to another db.

#2 Kriek

Kriek
  • Members
  • PipPipPip
  • Advanced Member
  • 31 posts
  • LocationFlorida

Posted 04 October 2003 - 03:51 PM

phpMyAdmin -> Database -> Export

-> Hold control and select all tables.

-> Check SQL, Structure, and Data.
Jon Kriek ยท PHP Freaks
Sometimes the need to mess with their heads ...
... outweighs the millstone of humiliation.


#3 chriss

chriss
  • Members
  • PipPip
  • Member
  • 10 posts
  • LocationZG, Poland

Posted 05 October 2003 - 08:50 AM

I can\'t use admin mode. I\'m on SunOS, not Win. I just want to know how to do that in mysql console.

#4 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 05 October 2003 - 04:38 PM

Try this

mysqldump -u username -p password databasename table name> table.sql

Import data

mysql -uuser -ppass database < table.sql

Check manual for more details
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users