689 reputation
1316
bio website crx.it
location Milan, Italy
age 39
visits member for 2 years, 3 months
seen 7 hours ago

...if it works, it's obsolete ;)


2d
comment Slow queries while using views in MySQL
Can you share the show create view theView and all the show create table XXX for every table involved in the view?
Oct
23
answered MySQLfabric — Manage setup problem
Sep
12
revised Is it possible to copy a dev. database schema over a prod. one, but keep the prod. database' data?
improved info
Sep
12
answered Is it possible to copy a dev. database schema over a prod. one, but keep the prod. database' data?
Aug
29
awarded  Yearling
Jul
24
comment Restoring a single database from mysql enterprise full backup
The table you want to restore is InnoDB or MyISAM? Because there are different approaches depending the engine
Jul
8
comment Auto backup only for MySql database and selected folders in WHM or via cron job command
Try to redirect the STDERR to a file like: /usr/bin/mysqldump -u USERNAME -p PASSWORD DATABASENAME > /home/Backup/backup.sql 2> /tmp/error.log and check/share the file /tmp/error.log after the execution of the cron job
Jul
8
awarded  Revival
Jul
1
revised MySQLSyntaxErrorException on ALTER TABLE … CONVERT TO … in MySQL Connector/J
improved tags
Jul
1
suggested approved edit on MySQLSyntaxErrorException on ALTER TABLE … CONVERT TO … in MySQL Connector/J
Jun
28
revised MySQLSyntaxErrorException on ALTER TABLE … CONVERT TO … in MySQL Connector/J
Improved info
Jun
28
revised MySQLSyntaxErrorException on ALTER TABLE … CONVERT TO … in MySQL Connector/J
Improved info
Jun
28
answered MySQLSyntaxErrorException on ALTER TABLE … CONVERT TO … in MySQL Connector/J
May
26
comment My auto increment primary key is not automatically incrementing
Try removing the ID colum/value declaration in your insert or use the NULL value instead of ''
Mar
6
comment Why does auto increment jumps by more than the number of rows inserted?
@QuestionOverflow a good starting point: dev.mysql.com/doc/refman/5.5/en/…
Mar
6
comment Why does auto increment jumps by more than the number of rows inserted?
Can you share your show variables like '%innodb_autoinc_lock_mode%'; output?
Mar
6
comment Why does auto increment jumps by more than the number of rows inserted?
MyISAM or InnoDB tables?
Feb
24
comment Issues with mysqldump after upgrade 5.5 -> 5.6
Are you shure that your mysqldump bin use the 5.6 version instead of 5.5?
Feb
6
answered Backup / Export data from MySQL 5.5 attachments table keeps failing!
Feb
6
comment Backup / Export data from MySQL 5.5 attachments table keeps failing!
@Mayb2Moro Wath about you net_write_timeout variable?