Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Should I backup the information_schema?

Soporose's profile image Soporose posted 10 years ago in Import/Export Permalink
Hi folks.

When doing a backup by Export, is it necessary to include the information_schema, or will just the database be sufficient to effect a recovery if needed?

Whenever I do an Export which includes the information_schema I get:

Table: PROFILING
Rows: error
Duration: SQL error (1289) The 'SHOW PROFILE' feature is disabled...

Table: USER_STATISTICS
Rows: error
Duration: SQL error (1227) Access denied; you need the PROCESS,SUPER privilege for this operation

I'm guessing these aren't important messages/omissions as far as a safety backup is concerned. Right or wrong?
ansgar's profile image ansgar posted 10 years ago Permalink
information_schema should never be backuped, for the same reason why you never backup the result of a SHOW TABLE STATUS result, or SHOW PROCESSLIST. This db only contains transient information which can be very useful at runtime, but never contains any real data you need afterwards for anything.
Soporose's profile image Soporose posted 10 years ago Permalink
Understood, and thank you.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.