[music legend]

i used this method to move mysite to another server and the database restored successfully and the site and everything is there but when i got to make a new post for some reason it ends up quoting old post for no reason and doesnt display what i typed in for the post....any ideas why?

[needaltuna]

Thanks for this much-needed tutorial.

I had no problems installing mysqldumper, but I have had some with creating directory protection, which, according to the msqldumper homepage, is urgently required. I keep getting this message: "There was an error while creating the directory protection !
Please create the 2 files manually with following content". I don't even know which two files it's asking for, unless it wants separate files for the username and the password.

--------------- Added 11 Nov 2007 at 05:23 ---------------

Sorted the situation out through cPanel. Everything is AOK now.

[TruthElixirX]

Originally Posted by music legend

i used this method to move mysite to another server and the database restored successfully and the site and everything is there but when i got to make a new post for some reason it ends up quoting old post for no reason and doesnt display what i typed in for the post....any ideas why?

I'd try resetting counters in the maintenance section of your Admin CP.

[Roonie]

I have used it to move a database from one server to another. I had never been so succesful in restoring a database!

Thanks you very much TruthElixirX

[TruthElixirX]

Originally Posted by Roonie

I have used it to move a database from one server to another. I had never been so succesful in restoring a database!

Thanks you very much TruthElixirX

Glad I could help.

[SVTCobraLTD]

Anyway to make this automatically happen. Say every 5 days or so?

SVT

[TruthElixirX]

Originally Posted by SVTCobraLTD

Anyway to make this automatically happen. Say every 5 days or so?

SVT

If your post supports Pearl.


It is a cron job you can run in some of the settings.

[princeedward]

nice tutorial...gonna try this one too...thanks bro....

[Nitro212]

nice, i tried it... works perfectly for all my db's can even ftp them to another backup server gotta test the cronjob thingy x_x

[Cybershaolin]

I have MySQLDumper running without any problem. This is a great tool to use. Thanks for the recommendation.

I would like to add something done like sending an email to an email account on another server. How would I do that?

[WildFire.ca]

This is a great tool for me as my host company Webserve.ca is trying to hold us hostage by not allowing us to do DB backup's. I have one question, when looking at my backups in an editor what is the output I should be looking for in the file to let me know it was done correctly.
Great product easy to install highly recommended it.
The output I got at the bottom of the table was this

--
-- Data for Table `xperience_shop_ta`
--

/*!40000 ALTER TABLE `xperience_shop_ta` DISABLE KEYS */;
/*!40000 ALTER TABLE `xperience_shop_ta` ENABLE KEYS */;

SET FOREIGN_KEY_CHECKS=1;
-- EOB

[mohammad6006]

i missed any size of attach table in transfering

can i restore and combine just this table?

[robbiefritz]

Installed and backed up. What a piece of cake. Great post!

Now my question for anyone with the time to explain. I want to install a test forum to upgrade with vb4. How do I go about restoring this backup to a new database that I can then use for my test forum? Do I even need to make a new database? I am a total n00b at this so forgive my ignorance.

Thanks!

[semmyz]

Hello,

I have a brand new forum and worked so much to get all the content on their. www.wfgsp.com

Now I need to know something. I am currently still a large noob but I get most things if simply explained.

So please please answer the following question for me


Other then backing up with database with the proiveded method, do i also have to download the physical forum through ftp and upload that to the new server? So basically to transfer to a new server. I just have to upload all the ftp files and upload the database with the provided method here?

Please guide me steps to successfully move my forum to a new server.

Thank you so much in advance, I will be most grateful.

-Sam

[rughis]

Thank you fot the excellent tutorial