67,128 reputation
1070158
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 8 months
seen 21 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


Feb
26
revised how to import mysql system “mysql” database
edited tags
Feb
26
revised how to import mysql system “mysql” database
added 616 characters in body
Feb
26
answered how to import mysql system “mysql” database
Feb
26
comment how to import mysql system “mysql” database
Did you restore to a different server running a different mysql version ? Did you change any config option in my.cnf on the restore machine that is different from the backup source ?
Feb
26
comment how to import mysql system “mysql” database
How did you backup the data (did you use mysqldump, tar, binary copy) ??? How did you restore the data ???
Feb
26
reviewed Approve suggested edit on What are the advantages of a database design with single table for MtM relationships?
Feb
26
revised SUPER privilege not defined for master user in Amazon MySQL RDS
deleted 13 characters in body; edited title
Feb
26
revised Amazon RDS for MySQL vs installing MySQL on an Amazon EC2 instance
deleted 84 characters in body
Feb
26
answered MySQL optimization
Feb
26
reviewed Close How to use 2 auto increment columns in MySQL phpmyadmin
Feb
26
answered Problem with order by in MySQL subquery
Feb
26
answered Create a mysql slave database from master database
Feb
26
reviewed Approve suggested edit on How do I get spatial index feature if I mainly use innodb?
Feb
26
comment Create a mysql slave database from master database
Please also run on the Master in mysql : SHOW MASTER STATUS;
Feb
26
comment Create a mysql slave database from master database
Please run this command on the Slave on the OS : ls -l /var/lib/mysql
Feb
25
reviewed Reject suggested edit on Mongo cannot find my collection
Feb
24
comment Safest way to perform mysqldump on a live system with active reads and writes?
@chudapati09 if you do not call the SLEEP function to keep the session open, the read lock will die immediately as the session terminates.
Feb
24
reviewed Approve suggested edit on PostgreSQL Hot Standby
Feb
23
revised How does mysql deal with queries that touches myisam and innodb tables?
edited tags
Feb
23
answered How does mysql deal with queries that touches myisam and innodb tables?