Standalone db req, that will be a prob!
Permalink
I was going to install C5 on my server for the local photo association the other day.
I then got the message that the db is not empty and that C5 need a standalone db.
Contacted the webhost and a second db can not be created.
Is there a way to install without removing the other stuff we have.
It's a newsletter we use so we need it!
Everything is prefixed so I don´t see why C5 would have problems with it.
Any solutions?
SUGGESTION FOR FUTURE RELEASES: Add a prefix to C5 tables =)
I then got the message that the db is not empty and that C5 need a standalone db.
Contacted the webhost and a second db can not be created.
Is there a way to install without removing the other stuff we have.
It's a newsletter we use so we need it!
Everything is prefixed so I don´t see why C5 would have problems with it.
Any solutions?
SUGGESTION FOR FUTURE RELEASES: Add a prefix to C5 tables =)
That was in my mind but I decided to write first.
There should be a reason in my mind before a restriction of that level is implemented.
But maybe upgrading is impossible later or something.
A checkbox in the install with "ARE YOU SURE" or something would solve it.
Everything in the db is prefixed with cap letters so there will be no problem because of that.
There should be a reason in my mind before a restriction of that level is implemented.
But maybe upgrading is impossible later or something.
A checkbox in the install with "ARE YOU SURE" or something would solve it.
Everything in the db is prefixed with cap letters so there will be no problem because of that.
Idea A:
Use phpMyAdmin...
1. Backup the other stuff to a SQL text file.
2. Check the text file to make sure it does not contaion any 'Drop' commands.
3. Make another backup just in case.
Because...
4. Empty out the database, drop and recreate, or drop all tables.
5. Install C5, make sure it works.
6. Import the SQL backup of your existing tables on top of the C5 tables.
If it doesn't work, delete everything and reinstall your existing database from the backup so worst case you are back where you started.
or B:
Make the same checks and backups, then hack the C5 installer so it doesn't need an empty database (not something I have looked into, so may not even be possible).