List:General Discussion« Previous MessageNext Message »
From:Jani Tolonen Date:May 12 1999 11:29am
Subject:dumping a db
View as plain text  
Timo Ernst writes:
 > 
 > hi folks !
 > 
 > i like to know how to dump a complete database (with the
 > create-structure
 > and the data) into a mysql 3.21 database ...
 > 
 > can anybody help me ?
 > 
 > there is always an error message 'line tooooooooo long' :((
 > 

Hello!

First dump the create definitions and data in text -files
(if the original database system is a MySQL database,
 you can use mysqldump --port=... --socket=... --tab=...)

Then you can do the create -commands on MySQL 3.21 database
and use mysqlimport to import the data in it.

Regards,

- Jani

-- 
+---------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___       ==  mysql@stripped         |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|       Jani Tolonen             |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|       mailto: jani@stripped      |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|       Helsinki                 |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____  Finland                  |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
|             /*/             \*\                   Developers Team   |
+---------------------------------------------------------------------+
Thread
dumping a dbTimo Ernst5 May
  • dumping a dbJani Tolonen12 May