is a .sql file transactional
when you run a .sql file, which modifies a schema, is it transactional? Specifically, is it an all-or-nothing proposition? Or, can some commands get executed, some fail? thanks, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: forum vs email
On Fri, 12 Dec 2014 10:31:53 +0100, Lucio Chiappetti wrote: I use nntp newsgroups, in a very simple threaded mode, I subscribe interesting groups and look at them once a day or sometimes more frequently. I skim through thread titles, expand the interesting ones, read the messages, then occasionally save an interesting one to a mail folder or reply and take part to a thread. Someday, in the far, far future, someone will re-invent usenet. Until then, there's gmane! although a surprising number of mailing lists have some sort of mistrust towards gmane. -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: is a .sql file transactional
- Original Message - From: thufir hawat.thu...@gmail.com Subject: is a .sql file transactional when you run a .sql file, which modifies a schema, is it transactional? Specifically, is it an all-or-nothing proposition? Or, can some commands get executed, some fail? A file is nothing more than just another input method, it has no impact on transactionality or any other parameters. DDL (schema modification) cannot be done inside a transaction - mysql will automatically commit your open transaction before proceeding, if you have one. Every DDL statement individually is, however, all-or-nothing - the server (mostly) makes a copy of the table you're operating on, and only switches them out if the change was successful. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Fresh install of MySQL 5.6.23 fails to start on CentOS 7.0
Cameron, Did you run the recommended configuration script manually? mysql_install_db This is run once after install to put the stuff in your datadir= location which I pointed out may be missing (and was empty upon your inspection). Thanks, Robert