RE: [PHP] ReFilling mySQL Database with CSV file!!

First structure only second data only Don't forget to check the check box for complete inserts and extended inserts reload in new db. create the DB upload the 1 file and then the second file Done > -----Original Message----- > From: Thomas Edison Jr. [mailto:thomasedisonjr@yahoo.com] > Sent: Friday, February 01, 2002 1:01 PM > To: php-general@lists.php.net > Subject: [PHP] ReFilling mySQL Database with CSV file!! > > > I have to shift my site to a new location. I have > enormous records in many tables in my database which > will be needed 2 be shifted to. > > The 'phpMyAdmin' at my site allows me make dumps of > the Data in the CSV format. I haven't done this > before. These are the options it gives me : > > 1. Structure only > 2. Structure and data > 3. Data only > 4. CSV for Ms Excel data > 5. CSV data : > Fields terminated by ; > Fields enclosed by " > Fields escaped by / > Lines terminated by \r\n > 6. Save as file > > Can someone please tell me exactly which option should > i be choosing? And also, once i have chosen that and > saved the lot of .csv files on my computer. What is > going to be the process to re-fill the new Database & > It's new tables with the data in the saved .csv File? > > Thanks, > T. Edison Jr. > > > ===== > Rahul S. Johari (Director) > ****************************************** > Abraxas Technologies Inc. > Homepage : http://www.abraxastech.com > Email : abraxastech@yahoo.com > Tel : 91-4546512/4522124 > ******************************************* > > __________________________________________________ > Do You Yahoo!? > Great stuff seeking new owners in Yahoo! Auctions! > http://auctions.yahoo.com > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > The information contained in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any form of disclosure, production, distribution or any action taken or refrained from in reliance on it, is prohibited and may be unlawful. Please notify the sender immediately. The content of the email is not legally binding unless confirmed by letter bearing two authorized signatures.