689 reputation
1316
bio website crx.it
location Milan, Italy
age 39
visits member for 2 years, 1 month
seen 5 hours ago

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


1d
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 suggested 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?
Feb
5
comment How to drop empty tables
@TomDesp we're here to help us ;) ... I agree with you about the possibility to drop system tables!