56,705 reputation
852132
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 2 months
seen 19 mins ago

One of JEHOVAH's Witnesses

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

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


Sep
28
reviewed Reviewed What happens to existing MySQL databases when I upgrade my Ubuntu distro?
Sep
28
reviewed Reviewed How to get non-deleted messages for one user_id if the same user_id appears in two tables at same time?
Sep
28
reviewed Reviewed Will a SP which writes records fail if accessed by a db_datareader role?
Sep
28
reviewed Approve suggested edit on Query from database
Sep
27
reviewed Reviewed My master to slave replication stopped and is showing this error when I use SHOW SLAVE STATUS;
Sep
27
reviewed Close Field not being sorted in ascending order in Visual Studio 2010
Sep
27
reviewed Close Who changed/modified stored procedure in SSMS 2005 or 2008?
Sep
27
reviewed Reviewed RETURN statement before DEALLOCATE CURSOR
Sep
27
reviewed Reviewed INFORMATION_SCHEMA Selection Error
Sep
27
reviewed Approve suggested edit on How can I improve this query
Sep
27
comment ERROR Cannot find or open table?
BTW +1 for extra mile in your answer
Sep
27
comment ERROR Cannot find or open table?
A hearty pirate Arrgghhh.....
Sep
27
comment ERROR Cannot find or open table?
The more I see stuff like this, the more I smile at the word mysqldump :-)
Sep
27
comment ERROR Cannot find or open table?
Perhaps every .ibd of the partition needs to be swapped in, not just the specific partition.
Sep
27
comment 'Access Denied' in MySQL on AWS RDS
let us continue this discussion in chat
Sep
27
revised ERROR Cannot find or open table?
added 17 characters in body
Sep
27
answered ERROR Cannot find or open table?
Sep
27
comment 'Access Denied' in MySQL on AWS RDS
You should be able to. Please review the DB security group you defined the instance with. Check the CIDR within it.
Sep
26
reviewed Approve suggested edit on Why would a SQL Server 2008 R2 database disable a table index when upgraded to SQL Server 2012
Sep
26
reviewed Approve suggested edit on MySQL import file with no column delimiter