[Solved] MYSQL backup question
Posted
#4836
(In Topic #976)
includes the table_prefix?
Hello,I used the Composr database backup tool today and then checked the log and it shows a success, but in naming each table it does not mention that I am using a table_prefix "new_"
My database contains two sets, the original database and then a new one with the prefix of "new_" ....
So I investigating by then doing a mysqldump and comparing the file sizes of the two database backups.
The mysqldump backup is twice as big as the Composr backup.
My guess is that the Composr backup is doing a backup of the normal tables and not including the new tables which use the prefix "new_" which is in my config.php file.
The site runs correctly, so no problem there, it is using the new tables.
I just wanted to check in on this matter
Thank you,
Stevyn
Last edit: by ironfeather
Posted
So it is backing up the right tables, you just won't see the table prefixes in the PHP/Composr-API-based query code.
Only tables referenced in the Composr site's meta-database are backed up (db_meta table).
Posted
Ok cool, Thank you for clarification on that.
1 guest and 0 members have recently viewed this.
