Tag Info

New answers tagged

1

It is feasible (you can chain-replicate more than 2 servers), but unnecessary: you can forward access using a VPN or, if you do not want to set that up, with simple SSH port forwarding. This applies even if you have a Windows server -you can install OpenSSH or any other SSH software or application that allows you to forward ports. SSH is the standard ...


0

After much Googling and messing about :-) I succeeded in getting it done ultimately due to this post here. It's quite simple and logical really - I just went down a few blind allies. Check out the answer by user1201232 and not the accepted answer - with a slight modification from me (experimenting!). You get your dump of your entire server as you have done. ...


0

Check that you have enough permission on both databases to see and select your tables. You could do a poor's man mysqldbcompare to check that: mysqldump -d -h server1 -u user1 -ppassword1 pressflow6 > objects1.sql mysqldump -d -h server2 -u user2 -ppassword2 pressflow6 > objects2.sql diff objects1.sql objects2.sql


0

You will need to install a fresh copy of MySQL and drop the raw data files into the new installation's Data Root, and then start the MySQL service.


0

In this case, it turns out that the problem was a misdiagnosis of symptoms. The debugger was simply failing to function for some as-yet unknown reason and the trigger was failing to do anything because it was properly executing its code. The conditional before the INSERT statement was missing a check to ensure it was only looking at the current user's ...


0

My initial guess would be based on the trigger's flow. Why ? According to the Book Chapter 11 Page 251 Paragraph 3 says the following: The most significant difference between BEFORE and AFTER triggers is that in an AFTER you are not able to modify the values about to be inserted into or updated with the table in question -- the DML has executed, and ...


-1

@ursitesion We also had a similar problem after we migrated our MySQL DB from Windows to Linux. We were lucky that our table names were already in small caps, the only issue we faced was that inside our application & some Stored Procedures (SP) we had mentioned the table names in Large Caps / Camel Case. We followed the following steps and were able to ...


0

I find that executing a FLUSH command helps in refreshing the SHOW SLAVE HOSTS output. It isn't deterministic; I sometimes need to execute two or three FLUSH commands, but it certainly refreshes. I found that either FLUSH LOGS or FLUSH STATUS do the job.


1

Here you have a video on the basic inner structure and inner workings of indexes. I recommend you to watch it all. Basically, indexes are ordered structures on disk (although they can be cached, and they normally will for better performance) that will allow certain operations to be done faster. In particular, in MySQL, B-tree/B+tree (the most common ones) ...



Top 50 recent answers are included