New Zenner
- Join Date:
- Mar 2007
- Posts:
- 57
- Plugin Contributions:
- 0
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
.
