• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Backup MySQL

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Whenever I make a backup of MySQL and transfer it to a new server with all of the same features, everything comes over except, it doesnt read any of the categories that are on there nor does it recognize all the users. It just goes to default every time. Im using phpmyadmin for the MySQL management.
[originally posted on jforum.net by confused2gether]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is "default" in this case? If you query the database by hand, the that is there at least?

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
When I say default, it will erase all of the topics and their respective categories and show nothing. Also, the bottom of the page will show only 2 users are entered in, even though there are many more. This is a huge issue since I really need to get the whole thing backed up successfully before I implement it.
[originally posted on jforum.net by confused2gether]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It seems that everything goes in there ok, and I dont get any errors upon the import, but jforum just isnt reading the tables correctly at all. If I browse using phpmyadmin into the jforum DB, I see that the posts are in there just fine but when I navigate to the website and clear out all of the cache in the browser and jForum, I get none of the posts or categories at all. If I log into the admin console, I can see the users, ranks, groups, and such, but the configuration is not there (which I'm guessing that is not tied in with the db and its just a file i need to bring over) but when I click on the categories page, none of the categories show up correctly, and when I click on the forum, I get the following error:



Is there a guide I should use on backing this up so that it works successfully? Are there other files that I need to be copying over to the other server for the data to read properly?
[originally posted on jforum.net by confused2gether]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
This is the HTML code that went along with that error from above:


[originally posted on jforum.net by confused2gether]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
There is nothing "special" about the jforum tables. To reproduce a jForum installation of the same version, you need the following.

1) An exact copy of all the jforum_tables. Note that your copy method must be able to deal with any autogenerated id fields. These have to stay the same as the original because they are used as foreign keys in other records. Your DB vendors should have instructions on how to do this sort of thing.. it's not jForum specific.

2) An exact copy of your jForum install with the exception of the configuration changes needed to point to the backup server, catalog, and a valid server user id/password. This should include the upload directory (and some others).

For this to work, it is best that any jForum webapp that uses the DB tables you are restoring or copying be shutdown while this is done and only started after the restore is done. This is the only way to guarantee the cache info is correct.

I suspect that the mechanism you are using is changing the autoincrement id fields when you copy. MySQL should have a way of recreating a table with the original id's. (Sorry I use MS SQL).

FWIW, we back up our production servers to a "backup" MS SQL server several times a day via it's Data Transfer Services utility. We've verified the ability to transfer to this backup by simply changing the db connection properties.

should be identical.
[originally posted on jforum.net by monroe]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
After going around and testing several things, the easiest way that I know how to do this backup is to install XAMPP & Tomcat Addon on my backup computer, then go ahead and copy the folders over to the backup computer, overwriting anything that is in there. This works for me and shouldn't become a problem since this forum will be used sparingly so the size shouldnt increase by much.
[originally posted on jforum.net by confused2gether]
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic