[Solved] MYSQL backup question

Post

Posted
Rating:
#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


Post

Posted
Rating:
#4838
High-level Composr queries do not involve the table prefix. The table prefix is added at a lower level. The backup works at the higher-level.

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).

Post

Posted
Rating:
#4839


Ok cool,   Thank you for clarification on that.     :rockon:  





 

1 guest and 0 members have recently viewed this.