★ wanayoo — archive 1999 http://www.devshed.com/Talk/Forums/Forum4/HTML/000288.htmlNouvelle recherche | Portail wanayoo
DevShed Menu
* DevShed Home
* Developer News
* DevShed Brain Dump




UBBFriend: Email This Page to Someone!
  DevShed Discussion Forums
  MySQL
  Databese convertion

Post New Topic  Post A Reply
profile | register | preferences | faq | search

next newest topic | next oldest topic
Author Topic:   Databese convertion
svetoslav
Junior Member
posted March 01, 2000 09:32 AM     Click Here to See the Profile for svetoslav   Click Here to Email svetoslav     Edit/Delete Message Reply w/Quote
I have a batabase made with mysql running on windows NT , but I have to use it on mysql on linux is there any ways to convert the database

rycamor
Member
posted March 02, 2000 11:00 AM     Click Here to See the Profile for rycamor   Click Here to Email rycamor     Edit/Delete Message Reply w/Quote
No need to *convert* it. Just use mysqldump to export all SQL commands used to build the database (you can also include all record inserts).

mysqldump -u [user] -p [database] > filename.sql

pipes the output to a text file, which you can then use to create the identical database on your Linux machine.

All times are MST (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | DevShed.com

Copyright © 1997-2000 ngenuity. All rights reserved.

Powered by: Ultimate Bulletin Board, Version 5.41a
© Infopop Corporation (formerly Madrona Park, Inc.), 1998 - 1999.