Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 Backing up database
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 17 March 2009 :  14:22:54  Show Profile
Hi, I wish to look at upgrading to the new version of the forum, I have never backed up our database and was wondering if someone can explain how thats done?

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 17 March 2009 :  14:24:31  Show Profile
Sorry about the signiture, dont have a clue how that all got there, but changed my forum password.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 March 2009 :  14:36:33  Show Profile  Send ruirib a Yahoo! Message
Well, if that's what I think it was, your account was hacked. Something people should think about before joining the forum owned by a guy who hacks people's accounts!

Regarding the backup, you can do it using phpMyAdmin. Never used it much, but I think there is an option for that, or for exporting your database as SQL statements. You should include data and structure.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 17 March 2009 :  15:25:12  Show Profile
Yep, I think it was hacked, anyway deleted and password changed, not sure what phpMyAdmin is, any pointers to it? Also I joined his forum a long time ago, only visited it once or twice, it never took me long to work out that this is the place to be for snitz

Edited by - thelodger on 17 March 2009 15:26:46
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 March 2009 :  16:07:57  Show Profile  Send ruirib a Yahoo! Message
Your host must have have info on a phpmyadmin interface to the database. You can see it as a web app to administer your MySQL database.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 17 March 2009 :  17:32:31  Show Profile
Cheers great help, I have now installed phpmyadmin via FTP and set up the correct details ip address and database name etc. sadly my host has decided thats all they can help me with, so I now have no idea on how to use it, any idiot guides about? or can you help me on how to do a simple full backup using it?
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 March 2009 :  17:56:54  Show Profile  Send ruirib a Yahoo! Message
Sorry, I have used PhpMyAdmin just a couple times, so I really don't remember it. I have used SQLYog instead, which is much simpler. SQLYog has a free version and I think you probably can use it, as the free version will allow you to backup the database, if your host allows outside connections to the server. Do you know if they do?

If you want to, email me the Db server details (server, username, password, database) and I wil have a quick look, backup the database for you and provide a link to a zipped backup version. If I can do it, means that you will also be able to do it, using the free version and you can start do it regularly.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 18 March 2009 :  01:16:52  Show Profile
Yes it does allow database backups from outside connections, I will email you my details, thanks very much for all your help on this, well beyond the call of duty.

Edited by - thelodger on 18 March 2009 01:20:05
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 18 March 2009 :  04:52:59  Show Profile
quote:
Originally posted by thelodger
... not sure what phpMyAdmin is, any pointers to it?
Available here.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 19 March 2009 :  18:27:04  Show Profile
Cheers to all, but a special thanks to ruirib who once again, went far beyond the call of duty.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07