Tag Info

Hot answers tagged

2

A .sql is a text file. more {file}.sql will show you the contents and instructions that will be executed if you feed MySQL the file. You do that with ... mysql -u {user} -p {database} < {file}.sql Careful though. This will add the file contents to {database} and can potentially kill your database. Therefor first examine the file and see what is in it. ...


2

Looking at the questions you posted the last few days, you've got a corrupt server. The .TMD is a temporary file, so move that to your /tmp directory, mv wp_posts.TMD /tmp and then try to do a repair table from the official MySQL 5.5 documentation. If that fails, your last hope will be this.


2

It is not safe to accept the removal of python2.7 because uninstalling python2.7 will also remove a lot of other packages that you need. The safe way to accomplish what you are trying to do in Ubuntu 12.04 is to install the version of MySQL Workbench from the default Ubuntu repositories. In order to do this, you need to repair your package catalog. Fixing ...


1

You have to change the postrm to purge the package: Open the file sudo nano /var/lib/dpkg/info/mysql-server-5.5.postrm Find the code snippet if [ -n "`$MYADMIN ping 2>/dev/null`" ]; then stop_server sleep 2 fi and comment the line stop_server if [ -n "`$MYADMIN ping 2>/dev/null`" ]; then # stop_server sleep 2 fi Save the file and purge ...


1

You can reset your MySQL instance with sudo dpkg-reconfigure mysql-server-5.5 If you are using another version of MySQL change the (5.5) (execute mysql --version from command line to find the version). After doing that use the username and password to connect from Virtualmin to your MySQL.


1

I know this question is about Ubuntu 10.10, but since 15.04 you can simply do: sudo systemctl disable mysql


1

Better not copy files to the fallback directory. Instead, either specify the parameter in command line, or add the following to my.ini / my.cnf: [mysqld] lc_messages_dir = /usr/local/mysql/share More details here


1

ALWAYS sudo apt-get update Basic: sudo apt-get install apache2 php5-common mysql-server libapache2-mod-auth-mysql php5-mysql Extras: sudo apt-get install php5-dev php5-gd Make sure you ALWAYS run mysql_secure_installation after you have installed MySQL


1

I'm all for teaching yourself how to do this kind of thing as a learning exercise, but figured I would mention that in addition to the respawn option mentioned in the comments, there are several options for doing this already written: Monit Supervisor Perp Daemontools There are probably others too. Most of these have published source too, so you can ...



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