BHerath
Jun 10 2008, 04:09 PM
| | 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! |
Reply
yordan
Jun 10 2008, 10:10 PM
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 ?
Reply
BHerath
Jun 11 2008, 02:08 AM
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.
Reply
yordan
Jun 12 2008, 09:27 PM
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 ?
Reply
TavoxPeru
Jun 13 2008, 09:26 AM
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,
Reply
Similar Topics
Keywords : mysql, backup, address,
- Mysql Multiple Tables
(1)
Any Website Provide Free Host Mysql Host?
(4) any website provide free host mysql host? i need it because i am using 000webhost.com now but it
only provide 2 mysql database... can i know where or how can i get more databases regards....
Mysql On Computer
XD (9) I posted PHP on computer? , but for some reason it doesn't show :/. Anyways I am wondering if
there is MYSQL on my computer, meaning can i make a data base on my computer? that way i make what i
want and upload it when i get hosted =)....
Mysql Database Entry By Excel Sheets
(2) Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
mysql database. Thanks....
Mysql Database Management
(1) Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE
(Store#, City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed
database for a bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST.
Consider that BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20.....
Mysql And User File_priv
(0) HI, I've hit the grain while trying to import file to mysql database - I need to enable file
permissions of the database user but this seems not possible with most of the hosting providers.
The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of
the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only
allow privileges on table querries but you cannot grant host file privileges to the database user -
which makes querries like: "LOAD DATA INFILE 'filename' INTO TABLE tablen....
I Have An Error With My Mysql Connection
mysql connection error (7) ok so here's my web page... http://lacrossems.t35.org/ it only lags cause its trying to
connect to the my sql server...i followed this guide
http://forum.ragezone.com/showthread.php?t=387249 and when i edit my config.php to my host and
login info i always get the error cannot connect to the database here is my config.php if you can
help me CODE <?php $host['naam'] =
'CENSORED'; // my host $host['gebruikersnaam'] =
'righto'; // my database username $host['wach....
Sun Bought Mysql
(6) SUN bought the swedish company MYSQL for much money, around 2million each worker got in the company,
they did it to come in to the database market, is it a good reson to buy it?....
Mysql Problem
Linking tables (1) Hello guys, I'm making a PHP/MySQL site for a friend of mine who plays an online game where you
can create towns, add buildings to them and upgrade them to a newer level. I've offered to make
him a small site where he can input his data into a database and keep track of his towns, buildings
and levels. I'll show you my database design and then explain what i want to do. Table: towns
field 1: TownID (primary key, auto-increment) field 2: TownName field 3: TownType field 4: Town
Description Table: buildings field 1: BuildingID (primary key, auto-incremen....
Mysql - So Hard
Come in here if you think MySQL is soo hard! (14) Doesn't anybody think MySQL is so hard to code? I mean think about it, you need loads of
databases just for one little script and you have to type things in like ;Host-Username:
(blahblah) ;Host-Password: (blahblah) ;Host-DatabaseName: (blahblah) Ok, that MySQL code was
random, and it is alot harder than that. If you have expierenced it being hard, you are free to
post right in here, mate.....
Mysql Script Help
help me lol, (3) ok im a real noob to this myswql stuff i know what its for but can any1 write me a script for it for
user sigh up and like a myspace type of profile with a forms peferbly Wii FC code Games. Also can
some1 explain how to add the forms if it doset bother u guys too much TY....
Not Understanding Mysql
(4) Im not understanding MySql stuff can someone help me when u got to the MySql site and all that other
stuff is this like a log of your web stuff or does it help u desigen your website just wanted to
know what it does and how do u use this thing.....
Apache Php With Mysql On Windows [solved]
(9) I have problems running PHP MySQL function in a windows set web environment. PhP scripts are
executed but if I try to use mysql connect and other like functions I get a blank window (while
using the browser). The command line client is working...I've added the path to libmysql.dll
and the extension=php_mysql.dll in the php.ini.....
Subqueries In Mysql
Using subqueries in MySQL. Very helpful. (1) This method is very useful. I always use this when simple queries of linking two tables is not
enough. This method is putting a query inside a query. Example: SELECT * FROM table1 LEFT JOIN
(SELECT * FROM table2 WHERE field1='id') AS subtable or joining multiple queries SELECT *
FROM (SELECT * FROM table1 WHERE userid='001') AS subtable1 LEFT JOIN (SELECT * FROM table2
WHERE field1='id') AS subtable2 You can join more than two queries depending on the output
you want. If someone already posted this topic here I'm sorry I don't know.....
Lost Connection To Mysql ,..., System Error: 111 In
(3) While I was trying to connect to my database or even create one using PhP mySQL I was given the
followoing error: Lost connection to MySQL server at 'reading initial communication
packet', system error: 111 in Has somebody encontered a similar report? I have my database
created using the cpanel together with a user name and password. I wonder if it is a server issue?
What can you do if you have not access to the configuration files?....
Mysql Query Question
MySQL Select query problem (3) Hii Guyz, I am having this little problem creating a query in MySQL. Problem description: Table:
mytable Table Structure: IssueId | ToolName | Status 01 | Tool1 | Open 02 | Tool1 | Closed 03 |
Tool2 | Closed 04 | Tool3 | Open Now, I want to get the results in the following form: ToolName |
Count(Open) | Count(Closed) For the above input, result will be: Tool1 | 1 | 1 Tool2 | 0 | 1 Tool3
| 1 | 0 There should be NO duplicate toolName in output. Thnaks, Manu.....
Oracle Vs. Mysql Vs. Postgresql
POLL!! Choses you preferred db s/w! (9) Hey Everyone!, Please choose your preferred database s/w! Regards, Avell....
Login System Using A Mysql Db
How do i do this? (5) Hi guys, ive got a registration system that looks something like the one below: Firstname:
Lastname: Then i have inset.php, which looks like the following: $con =
mysql_connect("localhost","autobot","abc123"); if (!$con) { die('Could not connect:
' . mysql_error()); }mysql_select_db("my_db", $con);$sql="INSERT INTO person
(username, password) VALUES ('$_POST ','$_POST ')";if
(!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 record
added";mysql_close....
Problems With Php Saving Data Into Mysql
HELP! I can't get my php documents to work with the mySQL (6) i have a server that says it allows php and mysql and in the control panel i can access mysqladmin
and phpmyadmin but i cant get the php to save data into the mysql, i am trying to make a text-based
MMOG so i need to save my users/passwords into a database(i thought) and it won't do it, can
anyone help me....
Mysql And Php
When trying to install Joomla (15) I don't know if this is the correct forum, but here is my question: I'm trying to test
Joomla and some forums in my computer, I have already installed MySQL with the GUI tools, Apache,
and PHP with the MySQL and MySQLi extensions, but when I'm trying to install Joomla I get this
error: Required Settings Check: ------------------------------------- PHP version >= 4.1.0
Yes - zlib compression support Available - XML support Available - MySQL support
Unavailable configuration.php Writeable Session save path Unwriteable Not ....
Permission Problem With Mysql Database Creation
Please Help! (8) I seem to have a problem with accessing my database with proper permissions. I have set the my
database correctly giving my db username all priviliges yet i seem to be unable to even log on with
this username with a denied access error. Any ideas on resolving this?....
Navcat For MySQL
is Navcat any good? (8) Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just
played around with the demo. Has any one used it beore, if so please let me know if its worth
buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility
and functionality. Regards....
Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database
(4) Hello to all of you beautifull people out there, I am new to MySQL, i just wanted to know if its a
good practice to directly store images and other binary files in a MySQL database. Any one with
help? Thanks....
MySQL, Multiple Tables
(24) Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always
learned ONE table... put EVERYTHING in one database table. I'm making a profile system so there
needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two
together? I could probably figure this out faster if someone explained and posted sample SQL code
that shows how the two are linked together. Thanks!! F....
MySQL Output Database Question
(18) I am new to MySql and have just created a database after using a script. My problem is not the
script, but what it says about putting it into the output file. I cant figure out the right terms
to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
please help me out?....
How To Connect MySQL With Flash?
Help me connect my flash Work with MySql (8) I know Flash and mysql but could not figure out if I could ever connect these? I want to have a
dynamic content in my flash object that could be retrieved from the database directly without myself
needing to update it again and again. How can I achieve this ? Do I have to install any additional
controls or connectors to do that ? If yes any one tell me....
Mirror My MySQL Database To Another Mysql Server
(4) Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
server?or create a small php script to do this? The reason is because, we all know that database is
very improtant if we have dynamic website. I have my forum hosted and i want to automatically
mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
that i forgot to backup my database..also i have one central backup database. Thanks for the
help..Im looking forward for this posibility.....
Recover Tables From A MySQL .frm File
(8) I have a couple of .frm files with no corresponding data or index files. Is it possible to recover
the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is
innodb....
MySQL Realtime Replication
how to replicate mysql in realtime (4) i dont know if this might be useful to ppl here, but this is a very good knowledge for serious
siteadmins. while i was digging for mysql backup techniques, i've found that mysql is able to
do realtime replication. the idea is that there are master server and slave server. both are having
the same version of mysql installed. the data flows; Master >copy> Slave ( in realtime!)
you'll never have to manually copy the database file of wasting your time to manually use the
mysqldump command. here are the links; http://dev.mysql.com/doc/mysql/en/Replication_HOW....
MySQL - Trouble With Bulk Insert Statements
(3) I'm trying to insert about 500 rows into mysql, but I keep getting errors. If I copy and paste
too many (about 50) insert statements at a time I get errors sometimes. I sometimes even get errors
but then the row is skipped so I don't know there was an error (I'm using linux and SSH).
What's the best way to get my insert statements to put the data in MySQL? Is there anyway that I
can have it tell me if there where any errors all the statements are executed? Thanks for your
help.....
Looking for mysql, backup, address,
|
|
Searching Video's for mysql, backup, address,
|
advertisement
|
|
