Welcome to Geeklog, Anonymous Wednesday, February 01 2023 @ 06:03 pm EST

Geeklog Forums

PHP Dump


Status: offline

Nightdude

Forum User
Chatty
Registered: 09/15/04
Posts: 61
angelic
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..
Giving it a try
 Quote

Status: offline

Nightdude

Forum User
Chatty
Registered: 09/15/04
Posts: 61
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??
 Quote

tokyoahead

Anonymous
[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

tokyoahead

Anonymous
[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
 Quote

All times are EST. The time is now 06:03 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content