Web Hosting Talk







View Full Version : mysql - importing .sql


roby2k
09-30-2002, 05:47 PM
i want to put a .sql in my d/b and i dont know how to i want to use the SSH command line

insiderhosting
09-30-2002, 06:06 PM
mysql -uusername -ppassword databasename < filetoimport.sql

-Steven

ghost
10-01-2002, 03:49 PM
Better, Why don't you use PHPMyAdmin :) :) :) Don't need to discover America again.

null
10-01-2002, 07:43 PM
mysql < data.sql

AdminLive
10-06-2002, 01:34 AM
Hi,

if your database is large then use SSH otherwsie go with PHPMyadmin.

Regards,

rockergrrl
10-08-2002, 03:17 AM
PhpMyAdmin doesn't like to import anything over 1mb, I've found (even then half the time if doesn't like to import then). It'll time out, and you'll have an incomplete import.