If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > DB data transfer

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-09-06, 11:13
Plarde Plarde is offline
Registered User
 
Join Date: Jan 2003
Posts: 54
DB data transfer

I need to recreate the MySQL data which is located at the host
to my local computer.
Is there an easy way to transfer the whole data base ?

Is there (like in SQL server) some files which contain all data
and which I could replace on my local PC.

Thanls for help,
Pierre.
__________________
Pierre (Pl-Arts)
Reply With Quote
  #2 (permalink)  
Old 01-09-06, 14:16
yellowmarker yellowmarker is offline
Registered User
 
Join Date: Jul 2004
Location: Dundee, Scotland
Posts: 107
Best to export the data from the MySQL host database and import it into your MySQL database on your local computer. For clarification, the export file would contain a series of SQL insert statements, and optionally include drop and create table statements.

I'd install and use phpMyAdmin instead of the command line, on each.

The data files you refer to do exist in MySQL under the MySQL install directory 'mysql/data' but I wouldn't touch them, or assume that copying them to another server would 'just work'.
Reply With Quote
  #3 (permalink)  
Old 01-09-06, 14:23
Ida Hoe Ida Hoe is offline
Registered User
 
Join Date: Aug 2003
Location: West
Posts: 98
From the command line(do not log on to mysql)

c:\mysql\bin\mysqldump -u [username] -p -r CreatesAFile.sql --add-drop-table [databasename]

will create a sql script that contains all the create table/insert data from your original db. Copy from host and run on new computer.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On