How to make a proper sql backup in phpmyadmin

Tutorials and how-to's.
Post Reply
User avatar
AYHJA
392
Posts: 37990
Joined: Fri Sep 17, 2004 2:25 pm
Location: Washington, D.C.
Contact:

#1

Post by AYHJA »



Should work perfectly for backing up your DB for safety, or for import using the bigdumpscript and so forth...
ImageImage
Image Image

BBcode:
Hide post links
Show post links
WAY
Site Admin
Posts: 2411
Joined: Sat Nov 06, 2004 4:43 am
Location: Sydney, Australia
Contact:

#2

Post by WAY »

For me, defaults work fine, just make sure 'Enclose export in a transaction' is checked, and that "gzipped"-style compression is selected

If you plan to wipe everything you have, you may as well check the Add DROP TABLE checkbox, but only if you want a clean insert..

BBcode:
Hide post links
Show post links
Post Reply