Database Backup system
Asked Modified Viewed 2,041 times
asked
I moved hosts recently and wanted to restore my settings from a previous host. I installed the most updated version of fusion, then went into Database Backup in the system admin, browsed for the backup, it was of the current version but has all my settings and personal mods that are stored in the database, anyway when I confirm that I want it restored the whole database is deleted rather than restored. If this is a server side thing please let me know.
answered
Not sure. But if there where a conflict in old and new server settings, it still should not erase you DB?
You might try to
1] Make a clean install of corresponding version of PHPFusion, but with a different prefix_ than you original installation
2] Import the old DB via your sites Backup facility
3] Change config.php to point to the original db_prefix
4] Drop the DB that was created during the "clean installation"
Is your modifications only stored in DB, or is modified files too? If so, you need to replace the files also, but you knew that.
You might try to
1] Make a clean install of corresponding version of PHPFusion, but with a different prefix_ than you original installation
2] Import the old DB via your sites Backup facility
3] Change config.php to point to the original db_prefix
4] Drop the DB that was created during the "clean installation"
Is your modifications only stored in DB, or is modified files too? If so, you need to replace the files also, but you knew that.
muscapaul
muscapaul 10
Paul
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
- Veteran Member, joined since
- Contributed 1,075 posts on the community forums.
- Started 8 threads in the forums
I have noticed that sometimes restoration of a database created on a server running MySQL4 to a server running a MySQL3 version poses a problem.
When I open the sql dosument in a text editor and replace
with
restoration goes quite well.
Maybe not entirely MySQL version related but settings related, but anyway, that is how I solved it.
When I open the sql dosument in a text editor and replace
Code Download source
) ENGINE=MyISAM DEFAULT CHARSET=latin1;with
Code Download source
) TYPE=MyISAM;restoration goes quite well.
Maybe not entirely MySQL version related but settings related, but anyway, that is how I solved it.
answered
Ok, muscapaul I did what you suggested because thats what happened with me, I went from version 4 to 3 of mysql. I tried loading the sql page that I had decompressed, when it went to the second screen after selecting the file it showed all the tables and what not that I wanted to restore to, but when I hit restore it would go to the main database backup page like normal, but the tables hadnt been restored.
What would I use to recompress it into a format the site willread?
What would I use to recompress it into a format the site willread?
Edited by Daywalker on 01-03-2007 14:38,
muscapaul
muscapaul 10
Paul
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
- Veteran Member, joined since
- Contributed 1,075 posts on the community forums.
- Started 8 threads in the forums
No idea, but maybe you can use PHPMyAdmin to import the edited SQL file.
Category Forum
Bugs and Errors - 6Labels
None yet
Statistics
- Views 0 views
- Posts 4 posts
- Votes 0 votes
- Topic users 3 members
0 participants
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions