Move a MySQL Database to another system

Spyros

I want to move a MySQL Database 3.23.54-max-nt from a Windows 2000
Server to a 4.0.14-max on a Redhat Linux Server.
Any idea will be welcome.
Thanks
Spyros

Jul 19 '05 #1

Subscribe Reply

5327

Rob Kings

spyros

Well I just did pretty much the opposite. From Linux to XP. Take a look at
mySQLDump. I don't have the exact syntax in front of me, but I dumped out
the database into a .SQL. This contains both the SQL to create the tables
and the data. Then on the target machine I created the new database:

C:\mysql\bin\my sqladmin create xyz -u root

Where xyz was the name of the database I wanted to create.

Then I imported the attached file using something like

C:\mysql\bin\my sql xyz < xyz.sql -u root

You'll have to look up the mySQLdump documentation (you can dump the entire
DB or just certain tables) and of course where I've used a DOS path yours
will be something like /mysql/bin/<whatever>

HTH

Rob
"Spyros" <sp*******@nets cape.net> wrote in message
news:4r******** *************** *********@4ax.c om...

I want to move a MySQL Database 3.23.54-max-nt from a Windows 2000
Server to a 4.0.14-max on a Redhat Linux Server.
Any idea will be welcome.
Thanks
Spyros

Jul 19 '05 #2

Rob Kings

I want to move a MySQL Database 3.23.54-max-nt from a Windows 2000
Server to a 4.0.14-max on a Redhat Linux Server.
Any idea will be welcome.
Thanks
Spyros

Jul 19 '05 #3

nospam

When I have to copy files from one system to another linux-win
win-linux or whatever I use the net to store a copy and download on to
the different system.
On Thu, 25 Sep 2003 12:06:38 +0300, Spyros <sp*******@nets cape.net>
wrote:

I want to move a MySQL Database 3.23.54-max-nt from a Windows 2000
Server to a 4.0.14-max on a Redhat Linux Server.
Any idea will be welcome.
Thanks
Spyros

Jul 19 '05 #4

nospam

I want to move a MySQL Database 3.23.54-max-nt from a Windows 2000
Server to a 4.0.14-max on a Redhat Linux Server.
Any idea will be welcome.
Thanks
Spyros

Jul 19 '05 #5

Similar topics

1474

Move a MySQL Database to another system

by: Spyros | last post by:

I want to move a MySQL Database 3.23.54-max-nt from a Windows 2000 Server to a 4.0.14-max on a Redhat Linux Server. Any idea will be welcome. Thanks Spyros

MySQL Database

3952

MySQL tips that I have come across

by: Mike Chirico | last post by:

Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest version of this document can be found at: http://prdownloads.sourceforge.net/souptonuts/README_mysql.txt?download

MySQL Database

2910

converting access db to mysql

by: chicha | last post by:

Hey people, I have to convert MS Access 2000 database into mysql database, the whole thing being part of this project I'm doing for one of my faculty classes. My professor somehow presumed I knew db's and gave me long list of things to do with that particular database, first thing being that particular conversion. Truth is that I don't know a first thing about db's, let alone using mysql... I downloaded mysql form www.mysql.com and...

Microsoft SQL Server

2253

Thinking of Access/jet to SQLServer or MySQL

by: Ian Baker | last post by:

We have developed an Access/Jet database (2000, XP & 2003 versions) that has been used by clients all around the world for several years and is extremely robust with 55 tables, 172 hard stored queries (plus about the same in VBA SQL code), 60 forms and about 18,000 lines of code. The biggest advantage with Access is that it doesn't cost the client anything for if they don't have Access already then we provide the Runtime version which makes...

MySQL Database

4648

Need info, books, articles,code, etc: Access VBA to XML to/from MySQL via HTTP

by: Cheryl Langdon | last post by:

Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to communicate with a MySQL database table on a web server, from inside of my company's Access-VBA application. I know VBA pretty well but have never before needed to do this HTTP/XML/MySQL type functions.

Microsoft Access / VBA

2313

New to MySQL......

by: Jim Hubbard | last post by:

I have a client that desires a new application for use at several stores in different cities. He wants "real time" access to all store data and the ability to continue to run locally even if the internet connection goes down. It occurs to me that a local MySQL instance should definitely be in each store to continue work if the net is down for any reason. But, what is the best way to synchronize/share data among all of the stores? ...

MySQL Database

8027

[mysql 5] How could I move a table from one database to another?

by: Man-wai Chang | last post by:

I have a *damaged* MyISAM stock_take_mst.frm in /var/lib/mysql/abc. And I would like to move it to /var/lib/mysql/test and experiment with it. Is there a MySQL command to detach and attach a table? -- iTech Consulting Co., Ltd. Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288

MySQL Database

38533

MySQL Basic Tutorial

by: Atli | last post by:

This is an easy to digest 12 step guide on basics of using MySQL. It's a great refresher for those who need it and it work's great for first time MySQL users. Anyone should be able to get through this without much trouble. Programming knowledge is not required. Index What is SQL? Why MySQL? Installing MySQL. Using the MySQL command line interface

MySQL Database

9705

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9575

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10320

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10073

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9134

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7609

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6846

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

3806

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2981

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General