ReFilling mySQL Database with CSV file!!
| From: | Thomas Edison Jr. | Date: | Fri, 01 Feb 2002 12:01:10 +0000 |
| Subject: | ReFilling mySQL Database with CSV file!! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-83111@lists.php.net to get a copy of this message | ||
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