My forums got hacked! Quick Question!!!

[joshcombs]

How can I use Linux to connect to mysql and reupload my database? I tried using phpmyadmin and the file was too large. Thanks

Josh

[mresell]

I think the consensus is us sqlyog or mysql-front. sqlyog being the better. Neither are free, but low cost.

[bigdave]

Hello If you have a dump of your database and mysql installed you can just do it from the command line:

mysql -h mysqXX.hsphere.cc -u username -p database < forum.sql
Enter Password:

You could also grab the tril of my manager from EMS its a pretty cool program as well:

http://ems-hitech.com/mymanager/

[Light Speed]

You don't have to upload the db all as one.

In phpmyadmin
You can do:
The entire DB or
a few tables at a time or
a table at a time or
you can even add an empty table and then insert line by line

An exported db is just file with txt

You do have a backup that you can open to access the data though don't you?

If so it should have info like this example:

CREATE TABLE `card_img` (
`card_id` int(20) NOT NULL auto_increment,
`cat_id` int(30) NOT NULL default '0',
`card_image` varchar(150) NOT NULL default '',
`card_thm` varchar(180) NOT NULL default '',
`card_template` varchar(30) NOT NULL default '',
`card_date` date NOT NULL default '0000-00-00',
PRIMARY KEY  (`card_id`),
KEY `cat_id` (`cat_id`)
) TYPE=MyISAM AUTO_INCREMENT=37 ;

So if you cut and past that into your SQl query window in phpmyadmin it will create a table called card_img.

in your db backup below the create table there should be insert statements for that table that look like this:

INSERT INTO `card_img` VALUES (15, 1, 'image/lsc_ecard_boutique_01.gif', 'image/lsc_ecard_boutique_01_thm.gif', 'horiz_temp', '2003-05-01');
INSERT INTO `card_img` VALUES (14, 1, 'image/lsc_ecard_badfairies.gif', 'image/lsc_ecard_badfairies_thm.gif', 'horiz_temp', '2003-05-01');
INSERT INTO `card_img` VALUES (16, 1, 'image/lsc_ecard_glamourpuss.gif', 'image/lsc_ecard_glamourpuss_thm.gif', 'horiz_temp', '2003-05-01');

If you cut and paste those into the query window it will add those to the card_img table. If you have hundreds of thousands of rows to insert you can do it in sections.

This method may not be pretty but it works fine and is easy.

[maytricks]

When I need to upload a dump I generally do it 3 or 4 tables at a time, for the larger tables, like templates, userinfo, I just break up.

[generic]

just for info, what got hacked and how?

[joshcombs]

Originally Posted by tracewebspace

just for info, what got hacked and how?

Vbulletin 2.2.8 it was a hole in the calendar.php page