Only partial manual db backup??

[StevenB]

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


.

[twiggy]

I am a complete newbie... I have struggled with almost everything for me website.

I was needing to do a back up and I actually got this on the first try!

I found this, maybe it will help:
http://www.zen-cart.com/forum/showth...ht=data+backup

Twiggy