Posted on: 12/11/04 06:18pm
By: Nightdude
I am just doing some more experimenting.
Let's say you have to use your latest phpdump backup.
What is the procedure for re-installing it into your database. I know how to upload a database downloaded directly from mySQL, have yet to figure out how to PHPDump.
Thanks..
PHP Dump
Posted on: 12/11/04 07:39pm
By: Nightdude
I figured it out, but why did I have to make the following changes
Lines starting with -- changed to #
All LOCK and UNLOCK I changed to # LOCK and # UNLOCK (didn't want to delete just in case)
Why the changes??
PHP Dump
Posted on: 12/17/04 02:35am
By: Anonymous (tokyoahead)
[Quote by: MySQL manual] As of MySQL 4.0.2, to use LOCK TABLES you must have the LOCK TABLES privilege and a SELECT privilege for the involved tables. In MySQL 3.23, you must have SELECT, INSERT, DELETE, and UPDATE privileges for the tables.
PHP Dump
Posted on: 12/17/04 02:35am
By: Anonymous (tokyoahead)
[Quote by: MySQL manual] As of MySQL 4.0.2, to use LOCK TABLES you must have the LOCK TABLES privilege and a SELECT privilege for the involved tables. In MySQL 3.23, you must have SELECT, INSERT, DELETE, and UPDATE privileges for the tables.[/QUOTE]
it seems its a permission issue on the server