Welcome Guest ( Log In | Register )



 
Reply to this topicStart new topic
> Mysql Backup With Another Address?
BHerath
post Jun 10 2008, 04:09 PM
Post #1


Newbie [ Level 2 ]
Group Icon

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!
Go to the top of the page
 
+Quote Post
yordan
post Jun 10 2008, 10:10 PM
Post #2


Way Out Of Control - You need a life :)
Group Icon

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 ?
Go to the top of the page
 
+Quote Post
BHerath
post Jun 11 2008, 02:08 AM
Post #3


Newbie [ Level 2 ]
Group Icon

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.
Go to the top of the page
 
+Quote Post
yordan
post Jun 12 2008, 09:27 PM
Post #4


Way Out Of Control - You need a life :)
Group Icon

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 ?
Go to the top of the page
 
+Quote Post
TavoxPeru
post Jun 13 2008, 09:26 AM
Post #5


Super Member
Group Icon

Group: [HOSTED]
Posts: 740
Joined: 8-April 06
From: Lima - Peru
Member No.: 12,579



QUOTE(BHerath @ Jun 10 2008, 11:09 AM) *
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,
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. MySQL - Trouble With Bulk Insert Statements(3)
  2. MySQL Realtime Replication(3)
  3. Recover Tables From A MySQL .frm File(8)
  4. Mirror My MySQL Database To Another Mysql Server(4)
  5. How To Connect MySQL With Flash?(8)
  6. MySQL, Multiple Tables(24)
  7. Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database(4)
  8. Navcat For MySQL(7)
  9. Permission Problem With Mysql Database Creation(8)
  10. Mysql And Php(15)
  11. Problems With Php Saving Data Into Mysql(6)
  12. Login System Using A Mysql Db(5)
  13. Oracle Vs. Mysql Vs. Postgresql(9)
  14. Mysql Query Question(3)
  15. Subqueries In Mysql(1)
  1. Apache Php With Mysql On Windows [solved](9)
  2. Not Understanding Mysql(4)
  3. Mysql Script Help(3)
  4. Mysql - So Hard(14)
  5. Mysql Problem(1)
  6. Sun Bought Mysql(6)
  7. I Have An Error With My Mysql Connection(7)
  8. Mysql And User File_priv(0)
  9. Mysql Database Management(1)
  10. Mysql Database Entry By Excel Sheets(2)
  11. Mysql On Computer(9)
  12. Any Website Provide Free Host Mysql Host?(4)
  13. Mysql Multiple Tables(1)


 



- Lo-Fi Version Time is now: 20th August 2008 - 11:11 AM