Importing into Database... how?

[jvanv8]

I have a mysql database on my local machine. I would like to dump the database contents and import them into the "live" database that resides on our server. phpmyadmin won't work because the dump file is too large.

Here is what I tried...
1. Dumped table called product into "product.sql"
2. Renamed the file "product.txt"
3. Uploaded the file onto the server (www folder called "mainwebsite_html").
4. Connected to server via SSH with "root" as user and navigated to the www folder
5. Executed command line:
[root@myhost mainwebsite_html]# mysqlimport -u dbAdminUserName -p mydatabase product.txt

Enter password:*****
mysqlimport: Error: Access denied for user: 'dbAdminUserName@localhost' (Using password: YES), when using table: product

What is going wrong here? The user name and password is the exact same username that I log into phpmyadmin with and the same one that I am using for php->mysql connections. I have tried everything and searched everywhere but have yet to find a solution.
Thanks for ANY help!

• John

[ahundiak]

Permissions can be tricky.

An alternate approach is wrtie a bit of php code which reads the file then executes the sql statements. That saves you from having to ssh into the server. Of course, you want to make sure that access to the script is secure.

[jvanv8]

ok, I got the permissions and user names all straightend out but I still can't import

I have been trying the "source" command. After uploading the sql dump to my server's var/www/html directory I then log in, navigate to that directory, then log into mysql and try this:
mysql> use mydatabase
mysql> source exported_db.sql

Sometimes it doesn't do anything. Other times it says it can't find the file. When it does find the file, it usally just spits back a few dozen lines like this:
ERROR:
Unknown command '\''.
ERROR:
Unknown command '\''.
ERROR:

Other times it only imports one command out of the thousands that the file contains.

????
- John