GIDForums  

Go Back   GIDForums > Computer Programming Forums > MySQL / PHP Forum
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

 
 
Thread Tools Search this Thread Rate Thread
  #1  
Old 14-Oct-2011, 08:58
PEANDRDEPT PEANDRDEPT is offline
New Member
 
Join Date: Oct 2011
Posts: 1
PEANDRDEPT is on a distinguished road

Import and Export of Data from Any Database to MySQL and MySQL to Any Database.


Import And Export Of Data From Any Database To My Sql And Mysql To Any Database is easily possible or not?
please help me i am fresher for mysql database
  #2  
Old 14-Oct-2011, 09:44
Texan40 Texan40 is offline
New Member
 
Join Date: Feb 2011
Location: Houston, TX
Posts: 29
Texan40 will become famous soon enough

Re: mysql


You can use mysqldump to dump a db to file. Details here : http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html
  #3  
Old 14-Oct-2011, 10:21
TurboPT's Avatar
TurboPT TurboPT is offline
Senior Member
 
Join Date: Feb 2006
Location: Atlanta, GA
Posts: 1,441
TurboPT is a jewel in the roughTurboPT is a jewel in the roughTurboPT is a jewel in the roughTurboPT is a jewel in the rough

Re: mysql


Texan40 provided the MySQL export utility, which makes it very easy in MySQL to dump data, any table + data, an entire database, or multiple databases.

As to importing, "easily possible" is a relative phrase, so I would add:

When importing the data, whatever the exported DB source data might be, will be simple as long as the "other" database can handle the data in similar form.

That is to say:
  1. The type of data in the export matches [or can at least handle] the corresponding table's data types where it will be imported
  2. Ensure that truncation is avoided. Especially for fields such as character, text and/or varchar types where their specified lengths may differ between the different DB tables. [Numeric types could also get truncated depending on their type]
  3. The column output of the data might make a difference if a specific column order is expected/required by the import to the other DB, and the "other" table's columns might not have the same order. There are other ways around this, but know this is sometimes an overlooked import hassle.
__________________
Use the force...read the source!!
WYCIWYG -- what you code is what you get!
Last edited by TurboPT : 14-Oct-2011 at 11:40.
 
 

Recent GIDBlogGID Spam Detector 1.1.0 by gidnetwork

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Starting Mysql server problem pjacks MySQL / PHP Forum 23 08-Sep-2004 17:23
how to post MYSQL data to web server bearky Web Hosting Forum 6 13-Jul-2004 05:08
MySQL Won't Work trs2988 C++ Forum 6 31-Mar-2004 08:48
MySQL Syntax Error DropZite MySQL / PHP Forum 3 09-Jul-2003 04:00
Windows: From only £20p/y,Linux: from $10p/m. ASP, ASP.NET, PHP, Free MySQL, +More EyotaHosts Web Hosting Advertisements & Offers 0 28-Jun-2003 13:54

Network Sites: GIDNetwork · GIDApp · GIDSearch · Learning Journal by J de Silva, The

All times are GMT -6. The time now is 05:02.


vBulletin, Copyright © 2000 - 2013, Jelsoft Enterprises Ltd.