Only partial manual db backup??
Hi all,
This is driving me crazy!
I decided to to a full recovery on another server for piece of mind and I discovered that my database backups just quit at around record 5000 in the admin activity log.
I have followed the instructions I found somewhere here:
These are the ideal settings to do a backup via phpMyAdmin:
NOTE: BEFORE clicking on "Export", you should select your database from the dropdown, so that its tables are displayed. THEN click on the "Export" tab.
* CHECKED: Structure
* CHECKED:
Add DROP TABLE
* CHECKED: Add AUTO_INCREMENT value
* CHECKED: Enclose table and fieldnames with backquotes
* CHECKED: Data
* CHECKED: Complete Inserts
* CHECKED: Extended Inserts
* CHECKED: Use hexadecimal for binary fields
* Export Type: INSERT
* CHECKED: Save as File
* Filename Template: __DB__
* Compression: "gzipped" (or whatever you prefer... gzip makes smaller files)
Additionally I have tried setting "Maximal length of created query" to 5,000,000 and tried leaving the field empty.
The server I am creating the db backup from is running phpmyadmin v 2.9.0.2
Can someone point me in the right direction to create a complete db backup?
Thanks for your help,
Steve
.
Stuff: ZC v1.37 | Linux | mysql v 4.1x | php v 4.4x | phpmyadmin v 2.6x | Default Template
Mods: Login Box v 1.41