When mysql-server is installed headlessly, there’s no password. Therefore to make .my.cnf work, it should have a blank password line. Here’s what I tested with for a .my.cnf: [client] user=root password= It’s also slightly strange to put .my.cnf in your vagrant user directory as owned by root and only readable as root. After ensuring the … Read more
From within your MySQL client, type tee session.out From that point on, all the I/O of in your current client session is written to the file ‘session.out’
Click on the table you want to change the color. Then on the left side, under the properties editor section you have a tab named Properties (tabs are positioned at the bottom of that area). Click on it and the first property you can modify is the color. The value should be entered in hexa … Read more
how about using federated tables on one of the servers? create the federated tables based on the remote tables you will use in the query and just run your query as if your database was all local. example below from MySQL site The procedure for using FEDERATED tables is very simple. Normally, you have two … Read more
You can use migration wizard from MySQL Workbench. Just choose the same local connection in both source and target selection, then change schema name on manual editing step. If nothing appears on manual editing step click next and the source and targets will appear. Click slowly on the source database name and edit to the … Read more
Hmmmm.. You have hit this NOT-A-BUG it seems. 🙂 If you change a global system variable, the value is remembered and used for new connections until the server restarts. (To make a global system variable setting permanent, you should set it in an option file.) The change is visible to any client that accesses that … Read more
You can alias the column names one by one, like so SELECT col1 as `MyNameForCol1`, col2 as `MyNameForCol2` FROM `foobar` Edit You can access INFORMATION_SCHEMA.COLUMNS directly to mangle a new alias like so. However, how you fit this into a query is beyond my MySql skills 🙁 select CONCAT(‘Foobar_’, COLUMN_NAME) from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = … Read more
Try something like this: SELECT * FROM clients WHERE CONCAT(field1, ”, field2, ”, fieldn) LIKE “%Mary%” You may want to see SQL docs for additional information on string operators and regular expressions. Edit: There may be some issues with NULL fields, so just in case you may want to use IFNULL(field_i, ”) instead of just … Read more
In Doctrine2 you have to use one of the following instead of NOW(). This: CURRENT_TIMESTAMP() Or: … createQuery(…’WHERE x.date = :now’) ->setParameter(‘now’, new \DateTime(‘now’)) … If you want only time or only date use one of those: CURRENT_TIME() and CURRENT_DATE() Documentation can be found here.
Try adding the –quick option to your mysqldump command; it works better with large tables. It streams the rows from the resultset to the output rather than slurping the whole table, then writing it out. mysqldump -uroot -h my.host -p’mypassword’ –quick –max_allowed_packet=512M db_name table_name | \ gzip > dump_test.sql.gz You can also try adding the … Read more