Backup and Reinstall the PM Installation

I'm having Network Solutions problems again.

35 minutes into sending out the first 972 e-mail newsletters, they shutdown our website claiming that the PHP site was being hacked.

They won't reopen it until we clear all PHP files and reinstall them. I can't figure out how to extract the files from MySQL and reload them.

Any clues?

export the database tables using PHP my Admin. then import them again:

http://www.techrepublic.com/blog/smb-technologist/import-and-export-databases-using-phpmyadmin/

In attempting to reinstall from pm1_users.sql I get the message:

localhost - powermessenger - pm1_users
Error
SQL query:

-- -- Dumping data for table `pm1_users` -- INSERT INTO `pm1_users` (`UserID`, `UserEmail`, `UserPassword`, `UserFirstName`, `UserLastName`, `UserCity`, `UserState`, `UserZip`, `UserEmailVerified`, `UserRegistrationDate`, `UserVerificationCode`, `UserIP`, `UserPhone`, `UserFax`, `UserCountry`, `UserAddress`, `UserAddress2`, `UserGroupID`, `UserSubscribed`) VALUES (19444, 'curibet@mac.com', NULL, 'Claudia', 'Uribe Touri', 'Miami', 'FL', '33129', 0, '2012-12-06 12:14:32', NULL, NULL, '305-858-1797', '', 'United States', '', '', 1, 1), (19441, 'lindsayupson@gmail.com', NULL, 'Lindsay', 'Upson', 'San Francisco', 'CA', '', 0, '2012-12-06 12:14:32', NULL, NULL, '415-686-9939', '', 'United States', '', '', 1, 1), (19426, 'robert@photocreditassociates.com', NULL, 'Robert', 'Tzall', 'New York', 'NY', '', 0, '2012-12-06 12:14:32', NULL, NULL, '212-710-1345', '', 'United States', '', '', 1, 1), (19427, 'erik@erikuecke.com', NULL, 'Erik', 'Uecke', 'Fairfax', 'VA', '', 0, '2012-12-06 12:14:32', [...]

MySQL said: Documentation

#1062 - Duplicate entry '19444' for key 1


Any idea what it's telling me?

I getting that for kfm_directories, too:


SQL query:

--
-- Dumping data for table `kfm_directories`
--
INSERT INTO `kfm_directories` ( `id` , `name` , `parent` , `maxwidth` , `maxheight` )
VALUES ( 1, 'root', 0, 0, 0 ) ;


MySQL said: Documentation

#1062 - Duplicate entry '1' for key 1



There has to be something I'm not doing correctly.

#1062 - Duplicate entry '19444' for key 1

it means there is already a record with ID 19444


you need to dump the database tables before importing.

Okay. How do I dump the table?

AH HA! Do I select it in the right listing and click on Empty?

in phpMyAdmin, select your database, on the structure tab, click the Empty (Trash Can Icon) button next to the table name. this will remove the existing records from the table.

Seamless. Thank you.

you're welcome.