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
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 skaffman says, use the –where option: mysqldump –opt –where=”1 limit 1000000″ database Of course, that would give you the first million rows from every table.
Use: mysqldump –extended-insert=FALSE Be aware that multiple inserts will be slower than one big insert.
As I haven’t seen it at serverfault yet, and the answer is quite simple: Change: ssh -f -L3310:remote.server:3306 user@remote.server -N To: ssh -f -L3310:localhost:3306 user@remote.server -N And change: mysqldump -P 3310 -h localhost -u mysql_user -p database_name table_name To: mysqldump -P 3310 -h 127.0.0.1 -u mysql_user -p database_name table_name (do not use localhost, it’s one … Read more