Tag Info

Hot answers tagged

8

I had got the same problem a few hours ago. First I've killed the stuck process (kill -9 PID, or complete restart) then I completely uninstalled mysql. sudo apt-get remove --purge mysql-server mysql-client mysql-common or sudo apt-get remove --purge mysql* This will uninstall all mysql related packages, what is in most cases a bit overkill... Be ...


3

Please try this first: apt-get purge mysql-server mysql-client mysql-common mysql-client-5.5 mysql-server-5.5 then reinstall mysql server. If this doesn't work only then try the following: sudo apt-get remove --purge mysql-server mysql-client mysql-common or : sudo apt-get remove --purge mysql* followed by : sudo apt-get autoremove sudo apt-get ...


2

It sounds like the /tmp folder has the sticky bits set This means your permission is denied due to protected_symlinks When protected_symlinks is set to "0", the symlink following behaviour is unrestricted. When set to "1" symlinks are permitted to be followed only when outside a sticky world-writable directory, or when the uid of the symlink and follower ...


1

Fairly old question, but still relevant on searches. phpMyAdmin uses plain PHP for config files, and the $cfg['Servers'] array to get the configured servers. So the proper way is to add a new config file in /etc/phpmyadmin/conf.d for every server you want to add. It's only required to end the files name in .php to get them included, but it's a good idea to ...


1

The simplest way to install all three is to run the lamp-server task: sudo apt-get install lamp-server^ The caret at the end means that this is running a task, not installing a package. There is no lamp-server package, so if you leave off the caret, apt-get will return the error message, Unable to locate package lamp-server. The task will install ...


1

LAMP would be overkill. That is intended for hosting a website. If you only need a database you can install MySQL. But that might be overkill too. There is also SQLite (it is a "light" database and I would opt for that). MySQL: sudo apt-get install mysql-server SQLite: sudo apt-get sqlite SQLite is a software library that implements a ...


1

I would actually just modify the SQL. MySQL has a SLEEP function you can select from. The following will inject a 10 second delay every 50 lines... And then just pipe that into the mysql command. awk '{print} NR%50==0 {print "SELECT SLEEP(10);"}' file.sql | mysql db_name


1

The missing errmsg.sys should be there. It's a binary file, from mysql-server-core-5.5 on my system. Try reinstalling that one?


1

One trick is to load the whole database into a RAM disk, if it fits. First, create a disk in memory: mount -t tmpfs -o size=350M tmpfs /var/tmp/ramdisk Adjust size as needed. Then move the database to this disk: rsync -av /var/lib/mysql/* /var/tmp/ramdisk/ chown -R mysql:mysql /var/tmp/ramdisk Then start the database server. In my.cnf you point the ...



Only top voted, non community-wiki answers of a minimum length are eligible