Jump to content


Photo

converting databases to sql


  • Please log in to reply
1 reply to this topic

#1 geisha666

geisha666
  • New Members
  • Pip
  • Newbie
  • 1 posts
  • LocationPA

Posted 26 August 2003 - 12:47 PM

hi! i have a basic grip of mysql, and would like to know if and how it is possible to convert a database into a sql file without re-entering all the information. i own a bookstore, and enter all my inventory into a program called homebase. this can be exported into comma or tab delimited files.

any help or direction to a site that would give me information/tutorials would be greatly appreciated. thanks!!

-- Kristina

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 26 August 2003 - 01:22 PM

Hi,

I would recommned you to refer the mysql manual

http://www.phpfreaks...mysqlmanual.php

To load data from a csv file

LOAD DATA INFILE \'<file_name>\' INTO TABLE <table_name> FIELDS TERMINATED BY \',\' LINES TERMINATED BY \'n\'

I would also recommend you a tool called sqlyoy which is a windows GUI based tool whcih can help you to execute batch script (.sql) and import/export data.

www.sqlyog.com
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users