close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Backup and Reinstall the PM Installation

Thread began 2/11/2014 4:35 pm by M2Media | Last modified 2/28/2014 3:49 pm by M2Media | 1839 views | 55 replies |

M2Media

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?

Sign in to reply to this post

Jason ByrnesWebAssist

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/

Sign in to reply to this post

M2Media

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?

Sign in to reply to this post

M2Media

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.

Sign in to reply to this post

Jason ByrnesWebAssist

#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.

Sign in to reply to this post

M2Media

Okay. How do I dump the table?

Sign in to reply to this post

M2Media

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

M2Media

Seamless. Thank you.

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...