The MU forums have moved to WordPress.org

What is this (mysql related) (4 posts)

  1. Konstan
    Member
    Posted 16 years ago #

    I've made backups of my site before and I never had these lines in them:

    /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

    This appears in the .sql file that my host backed up for me(it was too large for me, cpanel or phpmyadmin).

    I moved the dababase to another server and was having errors with those lines, so I just deleted them. Everything imported just fine, but I have a feeling that something might be missing.

    Do these do anything important? The database went from 4.1 to 5.0

  2. drmiketemp
    Member
    Posted 16 years ago #

    That's a dump file instead of an export. It's fine.

  3. Konstan
    Member
    Posted 16 years ago #

    Ah, thats why I've never seen them. I always backup :P

    Learning everyday.

  4. drmiketemp
    Member
    Posted 16 years ago #

    Yeah, flipped me the first time I saw it too. If you go further in the file, you'll start seeing lock commands and that's how I recongized what it was. Before mysql does anything that would affect a table, it will lock it first to prevent data corruption.

About this Topic

  • Started 16 years ago by Konstan
  • Latest reply from drmiketemp