LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 10-23-2003, 12:50 PM   #1
salscozzari
Member
 
Registered: Sep 2003
Posts: 36

Rep: Reputation: 15
Mysql help


This problem began with a Rootkit that infected on linux server at my work. This box was used to connect to another Linux machine and run reports with PHP.

I have been playing with Linux at home for the past few months and that qualified as the Linux expert here. The programers that set up the box are long gone. The original box is set up using E-smith from a few years ago. I got the infected box to boot up, but the PHP reports would not run giving me a bad function. I researched this and everything pointed to PHP not being configured --with-mysql... I tried to get PHP reconfigured on the old box and it would not work, don't want to go into that nightmare again.

Here is where I am now. I have Mandrake 9.1 loaded onto a box, I have Apache2, running on it and I have PHP and Mysql installed. PHP is able to now connect to the other machine and run some of the reports, that I brought over from the original infected box. I am elated with this.

Apache2 I cannot get to browse a directory, have tried a lot of things and will try more.

Here is the next step and I am hoping I can get some help here.

Mysql, all the data bases are on the infected machine. I can access everything on that machine. I need to set up Mysql on the Mandrake box and somehow bring those Databases over.

1) What kind of files am I looking for on the old box, will they have a particular .extension?

2) Is there an EASY way to bring those over and set them up on the new Mysql server?

Be gentle with me I am new here and learning as I go.

Gotta love trial by fire.

Thanks for any help.

Sal
 
Old 10-23-2003, 03:40 PM   #2
Looking_Lost
Senior Member
 
Registered: Apr 2003
Location: Eire
Distribution: Slackware 12.0, OpenSuse 10.3
Posts: 1,120

Rep: Reputation: 45
Here's one way you can try, in the original mysql to dump all databases and data into a script than can be read into the new one, cd into the mysql data dir:

mysqldump --all-databases --complete-insert --add-drop-table --result-file=mysqldatabase.backup

That should create a file mysqldatabase.backup
copy it over to the new machine, log into new mysql server and

source mysqldatabase.backup

should fingers crossed will set up the databases with the data in them again

Instead of --all-databases you can specify individual databases, and do one at a time

It's also possible to do it directly over the network I think but give this a go

Last edited by Looking_Lost; 10-23-2003 at 03:42 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 17 09-17-2014 03:13 PM
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock welery Linux - Software 19 03-06-2014 08:19 AM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. suziecorbett Linux - Software 8 10-09-2008 02:52 AM
Problems with MySQL on SuSE: Can't Connect (/var/lib/mysql/mysql.sock) neocookie Linux - Software 8 02-08-2008 12:48 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 06:34 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration