Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Dan Williams on October 20, 2003, 10:57:14 PM

Title: Import Twiggi Database
Post by: Dan Williams on October 20, 2003, 10:57:14 PM

Hello,
I know this is not a Twiggi support forum, but any help is greatly appreciated.
What I have done is on a working server that has been in place for about at year:
[root@sme5 /root]# mysqldump twiggi > twiggi.db.backup

Then on a freshly built server, I would like to import that db into a fresh install of twiggi.
I have read about the disaster recovery backups etc, but do not want all of that.

Is it possible to have a fresh install of the same version of the SME (5.6U6 in this case) and a fresh install of twigg, and then import that db file?

Thanks,
Dan

Title: Re: Import Twiggi Database
Post by: Craig on October 21, 2003, 08:10:18 AM

Dan,

all I have done in the past is to use WinSCP2 (a Windows SSH client) to copy the database from /var/lib/mysql to my Windows desktop and then copy back to the server and make sure that mysql is the owner and group owner.

I have had problems with dumping out Twiggi databases that are large.

Hope this helps.

Regards
Craig

Title: Re: Import Twiggi Database
Post by: Dan Williams on October 22, 2003, 01:56:27 AM

Hello,
I have done the fresh install of  SME5.6U6
Enabled Webmail
Installed Twiggi 1.10.16 from Contribs.org
Copied existing /var/lib/mysql/twiggi database to new server, set owner and group to mysql, and am getting  errors as follows loggin into twiggi as admin.
Error: Table 'twig_accounts' is read only, this error applies to other tables as well.
I did use MC to assure that they are not read only.
Beats me, I just wanted a smooth reliable method to do this from one server to another WITHOUT using the backup.
Dan

Title: Re: Import Twiggi Database
Post by: Dan Williams on October 22, 2003, 02:53:33 AM

Continuing along with this, I realized in my fresh server install that I did not have phpmyadmin rpm installed.
I grabbed that from the contribs site, and installed and can get in with no errors now. I am not sure the two are related?
Dan

Title: Re: Import Twiggi Database
Post by: Craig on October 22, 2003, 05:38:50 AM

Dan,

Glad it works.

I don't think the 2 are related myself either but if it now works thats great.

As I said previously I have had problems dumping a database that is very large.....I also have had problems trying to dump a database within phpmyadmin.

Regards
Craig