70,296 reputation
1170161
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 10 months
seen 2 mins ago

One of JEHOVAH's Witnesses (TV)

Seasoned MySQL DBA (SCMDBA) since 2007-08-11

Profile for RolandoMySQLDBA on Stack Exchange, a network of free, community-driven Q&A sites


22m
comment in Forward Engineering i have error called table does not exist
Did you generate this from MySQL database in Windows ? Are you loading this script into MySQL in Linux ?
2h
reviewed Approve Is it possible to use SQLite as a client-server database?
2h
reviewed Close no such column name
4h
reviewed Close Cannot open ssh tunne on MySQL
4h
comment Cannot open ssh tunne on MySQL
This post should go to ServerFault
4h
reviewed Close Phantom vs. Non-repeatable read
4h
reviewed Close Microsoft recommends using Rowversion over timestamp , but i can not find “rowversion” data type inside my sql server 2008 R2
9h
comment which mysql version to use - 5.1 or 5.5?
@Pacerier please keep in mind that I wrote this answer on January 4, 2013. I wrote this answer comparing 5.1 to 5.5. If you look at the question's very first comment, someone commented that 5.6 was not GA. Therefore, the latest 5.5 was stable on January 4, 2013. Today, that would be MySQL 5.6.22.
10h
comment which mysql version to use - 5.1 or 5.5?
@Pacerier yes the most recent GA version. For MySQL 5.6, use 5.6.21 and higher. For MySQL 5.5, 5.5.40 and higher.
17h
reviewed Approve Is MySql's LAST_INSERT_ID() function guaranteed to be correct?
17h
reviewed No Action Needed Results for every hour of the day even data if not present
17h
comment After mysql server restarts I cannot see my own database
If everything is normal again, please mark my answer accepted by clicking on the checkmark on my answer.
17h
comment After mysql server restarts I cannot see my own database
You can log in to mysql normally ???
18h
reviewed Close How to Shift a column up in a ring buffer?
18h
reviewed Close Backup Database Task - What's the number at the end of the filename?
18h
reviewed Close A way to clear/restart virtual memory creep automatically?
18h
comment After mysql server restarts I cannot see my own database
Run the following: service mysql restart --skip-grant-tables. You can login to mysql without a password. Please do that right now
19h
answered Is it possible: MySQL semisync and async replication on same master-slave pair?
1d
reviewed No Action Needed JDBC pooling Oracle driver Socket read timed out
1d
revised What does “as anonymous on” means in mysql's general log?
added 1850 characters in body