Hi, there is nothing simplier and faster than load data infile (LOCAL) since you can connect to the server
Mathias Selon "Berman, Mikhail" <[EMAIL PROTECTED]>: > Brian, > > How about an FTP service on your remote server? > > > Mikhail Berman > -----Original Message----- > From: Brian Dunning [mailto:[EMAIL PROTECTED] > Sent: Monday, June 13, 2005 10:01 AM > To: mysql@lists.mysql.com > Subject: How to load a remote db with lots of data? > > I have to load my remote MySQL db's with about a gig of data - > phpMyAdmin only allows me to upload a 15MB CSV file, so I have to > painstakingly separate my data into 15MB chunks and upload them one at a > time. It's a huge pain and takes about two entire days. Is there a > better solution?????? > > (My ISP blocks remote access to MySQL, so I have to use phpMyAdmin or > any other tool as long as I upload it. I'm not a command-line guy and > don't have a clue about that.) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
