|
|
|
|
![]() ![]() |
Jun 10 2008, 04:09 PM
Post
#1
|
|
|
Newbie [ Level 2 ] Group: Members Posts: 22 Joined: 8-May 08 Member No.: 30,211 |
I just got my site hacked!! (don't worry because it is not on astahost) Actually it is a wordpress blog. So I backed up my MySQL Databases with cpanel.
Now when I get my hosting approved here at astahost, can I restore those backups? Is the change of the site address going to interfere with this? Is there anyway I can edit those databases to work with my new address? Please help me out here! |
|
|
|
Jun 10 2008, 10:10 PM
Post
#2
|
|
|
Way Out Of Control - You need a life :) Group: [MODERATOR] Posts: 1,964 Joined: 16-August 05 Member No.: 7,896 |
You already opened another post with this problem. Try not to open several posts with the same subject, people will get lost and you will have less pertinent answers.
Concerning the database backup, you have to consider two things. First of all, you should use a tool like "phpmyadmin" to backup your database on a single text file, and use the same tool to create a database with the same name and restore the table contents. Secondly, this will only restore the data inside the tables. At this moment you will have to have a look a the way the data are used by the calling program, probably a php program, and how it interacts with the Apache web server. This is simply a backup/restore problem, some people here are very skilled on this. however, they will need more informations: which application is using your database, is this a forum, is this a wordpress thing, or a blog ? |
|
|
|
Jun 11 2008, 02:08 AM
Post
#3
|
|
|
Newbie [ Level 2 ] Group: Members Posts: 22 Joined: 8-May 08 Member No.: 30,211 |
I am sorry about posting everywhere, because I didn't first see the security topics.
It is a wordpress blog. It also has an autoresponder which uses a mysql database. Using the backup utility I downloaded the files and the databases. Maybe I could change some addresses in those files by opening them in notepad, and then I could restore the whole thing again here at astahost, using cpanel backup utility, when I get my hosting approved here. Is this possible? That is my biggest problem. |
|
|
|
Jun 12 2008, 09:27 PM
Post
#4
|
|
|
Way Out Of Control - You need a life :) Group: [MODERATOR] Posts: 1,964 Joined: 16-August 05 Member No.: 7,896 |
QUOTE Maybe I could change some addresses in those files by opening them in notepad You can already see if you see the word "localhost" in the files, you can for instance use the "search" option in Windows Explorer. Even better, have a look here : http://codex.wordpress.org/WordPress_Backups They give a full step-by-step backup/restore tutorial. I dod not test it because I don't use wordpress yet. Maybe some other forumers around here already tested the way to move a wordpress site ? |
|
|
|
Jun 13 2008, 09:26 AM
Post
#5
|
|
|
Super Member Group: [HOSTED] Posts: 740 Joined: 8-April 06 From: Lima - Peru Member No.: 12,579 |
I just got my site hacked!! (don't worry because it is not on astahost) Actually it is a wordpress blog. So I backed up my MySQL Databases with cpanel. Now when I get my hosting approved here at astahost, can I restore those backups? Is the change of the site address going to interfere with this? Is there anyway I can edit those databases to work with my new address? Please help me out here! Yes, you can edit the restored databases files and then import them to your new site. As i know, cPanel creates one .gz file for every MySql database you have on your server, each one contains a sql file with a complete database dump including all objects like tables (structure and data), indexes, etc. Best regards, |
|
|
|
![]() ![]() |
Similar Topics
|
Lo-Fi Version | Time is now: 20th August 2008 - 11:11 AM |