SQL Exports
- Thread starter Nebulous
- Start date
I've used this method regularly. I helped code the php back-end system of one of my brother's site, which involves storing customer information in the database.
I never bother checking the file size though ~razz~
I never bother checking the file size though ~razz~
CyberFreak
Legendary Typer
I always use phpmyadmin to make backups... Only because as your forum grows the backup/restore of phpBB3 isn't that good... There will come a point where you can't restore backups made via phpBB3 as they are too big and you hit the 30 seconds max execution time..
Yes, several times per week. phpMyAdmin is the only backup method I use, because it is the only one that works correctly. I had lost an entire forum once, because I didn't use PMA, but the phpBB backup. Luckily, I also has a recent PMA backup. ~cheesey_grin~
How do you download them?
I usually dont use any compression method when using phpbbmyadmin or phpbb3. If found that just the plain .sql file works better whereas Ive had problems using a gzip file to restore things in the past. I know you can extract a gzip file but I would rather just download the .sql file so I dont have to extract anything
I usually dont use any compression method when using phpbbmyadmin or phpbb3. If found that just the plain .sql file works better whereas Ive had problems using a gzip file to restore things in the past. I know you can extract a gzip file but I would rather just download the .sql file so I dont have to extract anything
CyberFreak
Legendary Typer
I usually use gzip compression and i haven't had any issues... I find it speeds up the download and restore as the file size to download/upload is alot smaller.
CyberFreak
Legendary Typer
I can never normally be bothered to wait for a 30mb file to download everytime i make a backup which is once or twice a day. Plus as i keep 30 days worth of backups so in total about 40 backups at once it would take up hell of alot of space if they weren't gzipped -razz-
CyberFreak
Legendary Typer
-lol- I take it you have search indexes then?...
CyberFreak
Legendary Typer
ACP ---> maintenance ---> Search index
There is 2 off them and they help with searching i think although we have never had one and it hasn't caused us any issues as you can run a forum without one.
One of the indexes increase the size of your posts table by about a half i think and the other one fills up the search mysql table with near enough as much data as the post table has.
There is 2 off them and they help with searching i think although we have never had one and it hasn't caused us any issues as you can run a forum without one.
One of the indexes increase the size of your posts table by about a half i think and the other one fills up the search mysql table with near enough as much data as the post table has.
I sometimes use the GZIP option, but usually just a normal SQL backup.
But a search index is important, because with out it, searching doesn't work at all. Like say, I went to Fowler's profile, and wanted to see the first few posts he made. The latest ones show up, but if I click any other than the latest, it will say it's unavailable, which I find irritating.
But a search index is important, because with out it, searching doesn't work at all. Like say, I went to Fowler's profile, and wanted to see the first few posts he made. The latest ones show up, but if I click any other than the latest, it will say it's unavailable, which I find irritating.
CyberFreak
Legendary Typer
Search does work... I can see my first posts including the original welcome to phpBB2 post -😉-
You won't be able to see it as it is a hidden forum. The earliest you should see if the promotion guidelines.
You won't be able to see it as it is a hidden forum. The earliest you should see if the promotion guidelines.
I always use GZIP as their is a max filesize for phpMyAdmin when restoring (localhost is much smaller but so I need it compressed as I do a lot of locahost testing).
If you use phpBB3's backup system it will never work for restoring your forum if any of the MODs installed have SQL edits as you will get SQL errors right away before you can restore your DB.
If you use phpBB3's backup system it will never work for restoring your forum if any of the MODs installed have SQL edits as you will get SQL errors right away before you can restore your DB.
Affiliates
