Hi ,
Can anyone tell me how to upload a table to mysql database using root, i tried phpMyadmin, but the file is too big, and it just crashes at the end.

Thanks in advance.

If you're uploading it via phpMyAdmin, you could increase the upload_max_filesize in /etc/php.ini to accomodate the size of the database you're uploading, or you could simply ftp the file in as which ever user, then via shell execute

mysqladmin -uroot -p create dbname
mysql -uroot -p dbname < mysql_dump_file_that_you_uploaded.sql

Note that if you use the latter method, you will need to grant the privileges from which ever user you wish to allow access to that database.

- Steve

Hi Steve,

Thanks for your help, i'm very new to this, can you tell me how to change directory on root? i mean i need to upload a file.sql from a directory that i have on a specifc domain or from my PC, to his database that i already have created.

So the question is how can i dump the file from my pc or from hhtp?

Best regards,
Abner
How can i dump from my pv