Can anyone tell me what the format is of the backup files that the forum creates. I mean, is it a file that I could import directly into phpmyadmin or is it a file that must go through the mybboard interface? Reason I'm asking is that normally I manually export the database via phpmyadmin using the SQL format every evening. But now I've set an automatic backup schedule via MyBB but those files inside the backups are not SQL files as far as I can see. I want to be sure to use the best method in backing up my database.
When you download a plain text file in the ACP it's .sql which you can directly upload via PHPMyAdmin.
The ones that save to the server are compressed as a .sql.gz IIRC. Basically if you unzip it, the same .sql file is there as it would be if you downloaded a plain text version.
Ok because I was a little confused. The file inside the .gz does not have an extension at all when unzipped while the manual backup via phpmyadmin has the .sql extension
Basically, if you want to download, it's best to use a plain text (unless you have a big board). If you backup to the server, you can upload that via the ACP, and MyBB does whatever it needs to to upload it from the .gz.
(2008-10-03, 08:30 PM)Matt_ Wrote: [ -> ]If you backup to the server, you can upload that via the ACP, and MyBB does whatever it needs to to upload it from the .gz.
But that's my problem. I need to be sure that I'm not dependent on the MyBB system for restoring a backup. I once needed to upload a backup for PHPBB 2 and for some reason it couldn't handle the file because it was too big. It took days to work that out. So I need to be sure that I can use the file inside the .gz file within phpmyadmin to restore a backup directly instead of being forced to use it via MyBB (just to be safe).
But as I understand the file within the .gz is simply the plain text version which can be imported via phpmyadmin to restore a database?
If you download it there's always some way of getting it to work with PHPMyAdmin. The file in the .gz file should be the same as the plain text .sql files, it's just compressed as a .gz.