|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
July 31st, 2000, 02:21 AM
|
|||
|
|||
|
how to export the data from mysql database to a text file and how to import the data from text file to mysql database.
If any one have the solution for this problem please send it as early as possible. with regards Narayana Rao
|
|
#2
July 31st, 2000, 09:54 PM
|
|||
|
|||
|
use the mysqldump binary
|
|
#3
August 7th, 2000, 06:13 PM
|
|||
|
|||
|
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by nnrao18:
how to export the data from mysql database to a text file and how to import the data from text file to mysql database. [/quote] As guy before said, see the mysqldump. Works great, but if your version of mysql supports, use the --opt flag. You can also get table definitions like this: mysqldump [-u user] [-pPASSWORD] -d database >databases-d.dump I'm doing a compare of oracle and mysql (for features I use a lot in mysql I need to find in oracle): http://www.rede.com/rdbms/mysql2oracle.html Peter
|
|
| Viewing: Dev Shed Forums > Databases > MySQL Help > exporing and importing of data |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
