Re: [PHP] ReFilling mySQL Database with CSV file!!
Thomas, What phpMyAdmin is doing is providing a graphic interface for mysqldump. So read the MySQL docs on that and it will give you a better idea of what you're getting. What facilities do they provide at the new site? Will you have a shell, or is it a web interface? Will they provide a default database name to which you add your own tables and data? The other problem is file size. Will you encounter any file size limitations uploading to your new provider? Let's assume you do a dump with the data and structure to olddata.sql. You have ftp'd the file to /home/joe at the new ISP. The database name provided by the ISP is bftsplk, you have shell access and can use the mysql command line. To import your data you would simply issue: mysql bftsplk < /home/joe/olddata.sql This will recreate your tables and load them with data. The extension on the dump file does not matter, I just use .sql to tell me it is a different type of text file. If the new location uses phpMyAdmin, you'll have to find out what options are provided for creation of tables and import of data. The administrator may be willing to do the import as part of your setup. HTH - Miles Thompson At 04:01 AM 2/1/2002 -0800, Thomas Edison Jr. wrote: >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 : [EMAIL PROTECTED] >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: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] ReFilling mySQL Database with CSV file!!
"Thomas Edison Jr." <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 2. Structure and data This is the one you want. It's not CSV (comma separated values), but rather the complete SQL code used to build your entire database. You'll be able to import this into your new phpMyAdmin, or just pipe it into the mysql command line client (assuming you have access to that). Take care, Hendrik -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]] > Sent: Friday, February 01, 2002 1:01 PM > To: [EMAIL PROTECTED] > 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 : [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > 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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 : [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]