5

Restore mysql databases that is created using direct admin

view full story
linux-howto

http://serverfault.com – PS: I'm sorry my description is a bit long. I am just trying to give all the information. At first, I was not able to login to direct admin. I research on the web on what are the causes and found out that directadmin cannot make sessions when the disk is full. I check through ssh and found out that the root directory was indeed full. To be able to login to directadmin and start mysql, I decided to add a soft link of the /var/lib/mysql/ to /home/mysql. Since my database used up the most of the root directory. I move first the /var/lib/mysql to /var/lib/mysql.mark before I created the softlinks (HowTos)

grtyyu's picture
Submitted by grtyyu on 12/13/2012 – Made popular on 12/13/2012

Stories similar to Restore mysql databases that is created using direct admin

I was setting up a soft link in linux. Here were the steps I followed:

> groupadd mysql > useradd -g mysql mysql > cd /usr/local > gunzip /home/Tim/Download/mysql.....gz | tar xvf - > ln -s /usr/local/mysql.... mysql

Seems that you might be missing a file--at least, that's what the error is telling you.Confirm that mysql-bin.index exists in your ~/.mysql directory and try starting it again. Also, all files (and the directory containing them) should be set to mysql:mysql and the parent directory's permissions should probably be set to 0750 or 0770.

I really did it this time.. I deleted a database named MySQL in my server. Shortly after MySQL went haywire and now I cannot login as a user to mysql, I cannot re-install mysql, I get an error for every solution I try.

So I decided hell with it I'll remove mysql, php and start again. I used rpm -qa | grep mysql but it returned nothing.

I've changed data directory in /etc/my.cnf.

A bit ago, I moved my mysql directory from /var/lib/mysql to /home/lib/mysql. In those steps I created a symlink

ln -s /home/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock

Which worked great. Today, I had to restart mysql through WHM. When I do, it says it failed and mysql isn't running. Trying again doesn't work.

Hi everyone.

I recently setup a Ubuntu 12.04 LAMP Server at home that I use to develop websites in corporation with clients. I've been using Ubuntu and other Linux distros for a few years, but I am new to servers and have been learning a lot.

The story: A couple days ago I had created a new database and added a table to it using phpMyAdmin running on the Chrome browser. I then attempted to do something else, don't remember what, using the same software, when Chrome crashed. I then could not get into the database using my name.

I was trying to move the MySQL tables so them were in another folder, so I messed out the plugins table or something like that and I ended up reinstalling the whole thing.

I did sudo aptitude purge mysql-server then I removed the MySQL data rm -rf /var/lib/mysql/mysql and also I removed the data from the other directory I was trying to move the tables.

After reinstallation I supposed I would be

I have linux root password. There's MySQL server on that machine. One of the site's ini was rewritten and now it can't reach the mysql database. I don't have mysql root to change the password for database user. The server owner is now in vacation, so I can't ask him to give me the mysql root. I can reset mysql root password, but I don't want.

I need:

Save current mysql root password hash somewh