473,287 Members | 1,868 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Migrate mysql server

How do I migrate (copy) mysql database to another server/machine.
Feb 19 '08 #1
2 1566
Hi,
use mysqldump command
Feb 19 '08 #2
Markus
6,050 Expert 4TB
If you are using phpmyadmin, you can go to any table you have created and then use the 'export' link at the top.

Make sure SQL is checked in the next page you come to, and then carry on.
It will give you a load of code; copy this and then go to your new servers phpmyadmin.

Open up the 'SQL' tab and then paste the code into the textarea.

Query it, and you're done!

But then again, if you're not using phpmyadmin (shock) this isn't very helpful :P
Feb 19 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Phil Powell | last post by:
I've read some online resources that utilize various MySQL command-line actions to migrate data from Access to MySQL. The situation is this: a group of co-workers of mine will be using an Access...
4
by: Bon | last post by:
Hello all Would it be possible to migrate the MS Access 2000 to MS SQL Server 2000? My application is using MS Access 2000 as database and as user interface such as forms. Now, I want to...
1
by: Bruno BAGUETTE | last post by:
Hello, Where is the tool to migrate a mysql db to a PostgreSQL db ? The only thing I can find is an empty projet in the Gborg http://gborg.postgresql.org/project/mysql2psql/projdisplay.php ...
5
by: Fabio Benavides Murillo | last post by:
> Hello > > I have a problem, I want to migrate the data of a postgres' database to a > mysql's database, this because i need to move to a windows. > > I tried making a postgres' backup using...
1
by: Davor | last post by:
I have to migrate database from AIX DB2 to MS Sql Server 2000. In one table there is field with GIF image. I have tried with "Import/Export Data" wizard on SQL server to import that table. All...
0
by: Gee | last post by:
To migrate the VSAM files to SQL server 2000 I need to load 'OLE DB provider for AS/400 and VSAM'. To load the provider I've to install Host Integration Server. But the cost is too high. Please...
9
by: Algonquin J. Calhoun | last post by:
I've developed an application that exceeds the Access 2GB limit. This application was developed as a prototype and the users have found it very useful. Approximately 45,000 records are added to...
2
by: hebollozos | last post by:
Can anyone help me by giving me instructions how to migrate my MySQL Data for Windows to MySQL for Linux. I tried to find Sqlporter software by Realsoft Studio, but I failed. Hope somebody out can...
0
by: SLauren | last post by:
Hi friends, Are there are any guidelines for migrating mysql stored procedures to sql server manually? Please suggest. Regards, SLauren
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.