WHOA! These aren’t really comments even though they look that way. They are conditional-execution tokens. Take this line: /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; If the version of mySQL is 4.00.14 or higher, then the MySQL server will run this statement. This magic comment syntax is documented in the Comment Syntax section of the manual. You … Read more
Your MySQL binaries should be somewhere under your XAMPP folder. Look for a /bin folder, and you’ll find the mysql.exe client around. Let’s assume it is in c:\xampp\mysql\bin, then you should fireup a command prompt in this folder. That means, fire up “cmd”, and type: cd c:\xampp\mysql\bin mysql.exe -u root –password If you want to … Read more
As @Devart says, the total length of your index is too long. The short answer is that you shouldn’t be indexing such long VARCHAR columns anyway, because the index will be very bulky and inefficient. The best practice is to use prefix indexes so you’re only indexing a left substring of the data. Most of … Read more
You can use the exec() function to execute an external command. Note: between shell_exec() and exec(), I would choose the second one, which doesn’t return the output to the PHP script — no need for the PHP script to get the whole SQL dump as a string : you only need it written to a … Read more