geisha666 Posted August 26, 2003 Share Posted August 26, 2003 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 Quote Link to comment Share on other sites More sharing options...
shivabharat Posted August 26, 2003 Share Posted August 26, 2003 Hi, I would recommned you to refer the mysql manual http://www.phpfreaks.com/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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.