Backup MySQL

[Migrated From Jforum.net]

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]

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]

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]

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:

Expression repository.getCategory(category.id) is undefined on line 21, column 43 in default/admin/forum_list.htm.

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]

This is the HTML code that went along with that error from above:

Expression repository.getCategory(category.id) is undefined on line 21, column 43 in default/admin/forum_list.htm. The problematic instruction: ---------- ==> assignment: forums=repository.getCategory(category.id).getForums() [on line 21, column 25 in default/admin/forum_list.htm] ---------- Java backtrace for programmers: ---------- freemarker.core.InvalidReferenceException: Expression repository.getCategory(category.id) is undefined on line 21, column 43 in default/admin/forum_list.htm. at freemarker.core.TemplateObject.assertNonNull(TemplateObject.java:124) at freemarker.core.TemplateObject.invalidTypeException(TemplateObject.java:134) at freemarker.core.Dot._getAsTemplateModel(Dot.java:78) at freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:86) at freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at freemarker.core.Assignment.accept(Assignment.java:90) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:79) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:160) at freemarker.core.Environment.visit(Environment.java:351) at freemarker.core.IteratorBlock.accept(IteratorBlock.java:95) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.Environment.process(Environment.java:176) at freemarker.template.Template.process(Template.java:232) at net.jforum.JForum.processCommand(JForum.java:233) at net.jforum.JForum.service(JForum.java:200) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:686) at java.lang.Thread.run(Unknown Source)

[originally posted on jforum.net by confused2gether]

[Migrated From Jforum.net]

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]

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]