Uploading a db
| From: | ioannes | Date: | Sat, 27 Nov 2004 23:41:47 +0000 |
| Subject: | Uploading a db | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37425@lists.php.net to get a copy of this message | ||
What is a good way to load a database which I have served in a sql file (with all the sql statements etc). I have tried a GUI called Mascon, and a terminal command mysql -u user -ppassword db_name < file.sql with no luck due to various errors, including too large packet size, need reload privilege and authorisation problems. I was hoping to avoid trying to extract it all and insert all the records. Should I be looking at PHPMySQLAdmin or is that only for Administrators (I am a user on a shared internet server).
John