[tcih]

Heip,

I have problem with Ubuntu 10.04.2 Server edition.
It was sabotaged by deleting all the mysql and mysqld folders in it.

Tryed removing, reinstalling mysql, but it does recreate only few folders and files.
Default files that come with base install of ubuntu are still gone. Without them i cant start the MSQL server.
The MSQL was not configured nor had any DB's, but I have a need for MySql now.

For example my mysqld.sock is missing. Linking the one in /tmp does not work.

I have no backup.

[devper94]

Hope this isn't too late.
Run

sudo apt-get remove --purge mysql-server*
sudo apt-get install mysql-server
# add more package if needed
# if necessary run:
#dpkg-reconfigure mysql-server-VERSION

[tcih]

Hi Junior

I bet /var/run/mysqld dir was also removed. I did purge remove and also install again without errors and then i did dpkg reconfigure, entered new pw and that was it.

root@gn49:~# dpkg-reconfigure mysql-server-5.1
stop: Unknown instance:
110728 11:49:06 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibiLjyki' (Errcode: 13)
110728 11:49:06  InnoDB: Error: unable to create temporary file; errno: 13
110728 11:49:06 [ERROR] Plugin 'InnoDB' init function returned error.
110728 11:49:06 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
start: Job failed to start


root@gn49:/etc/init.d# mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

root@gn49:/# find -name mysqld.sock
root@gn49:/#

[devper94]

Error log please

http://dev.mysql.com...erver-logs.html

P/s: my name is devper94

[tcih]

I know, just noticed that i have been registered here longer than You

Here is the log:

mysqld --user=root --log-error &




110728 19:18:07 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
110728 19:18:07  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
110728 19:18:08  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
110728 19:18:08  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
110728 19:18:08  InnoDB: Started; log sequence number 0 0
110728 19:18:08 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
110728 19:18:08 [ERROR] Do you already have another mysqld server running on port: 3306 ?
110728 19:18:08 [ERROR] Aborting

110728 19:18:08  InnoDB: Starting shutdown...
110728 19:18:09  InnoDB: Shutdown completed; log sequence number 0 44233
110728 19:18:09 [Note] mysqld: Shutdown complete

[devper94]

Quote

110728 19:18:08 [ERROR] Do you already have another mysqld server running on port: 3306 ?

You might want to run service mysqld stop then service mysqld start.
That's the proper way to start mysqld.

[tcih]

root@gn49:/etc/init.d# service mysqld stop
mysqld: unrecognized service
root@gn49:/etc/init.d# service mysql stop
stop: Unknown instance:
root@gn49:/etc/init.d#

[devper94]

Have you tried service mysql start and then connect to the MySQL server?

[tcih]

devper94, on 29 July 2011 - 09:04 AM, said:

Have you tried service mysql start and then connect to the MySQL server?

Yes

~# service mysql start
start: Job failed to start

*Sorry i was afk for a few days.

[devper94]

After starting up is mysqld running?
First kill any mysqld running, then service mysql start.
If you get no error, then try to connect.
If you get errors, killall mysqld again to be sure, then mysqld --user=root --log-error and redirect the error to a log file.
Also post the files /var/log/mysql*

[tcih]

It can not be solved, have ben looking into this topic for verly long time, close please

[devper94]

I don't think this is a completely lost case.

Purge the MySQL packages, clean up everything left and install it again.

[tcih]

Well i remember that i tryed purge also, but that did not make any much change.