Forums

I am looking to have certain forms written to a separate data base, and not the main Joomla DB.

I created a new data base, user and password. Then in Chronoforms admin, created a new table, then added the save to DB action that included the new table info, DB name, user and PW but get a connection failed.

I thought creating a table in Chronoform admin would create the table in the new DB but guess not. How can I create a new table in the new and separate data base?

Hi jjspelman,

The Create table icon only works on the current Joomla! database/schema.

Use PHPMyAdmin to create the table in the other database. If you want a standard ChronoForms table you can create it in the Joomla! database then use PHPMyAdmin Export to get a Create query. Modify the query to match the other database name and Import it back in there.

Bob

Hope I did it right, but I simply exported the table from the Joomla DB then imported into the new. I didn't "modify" the exported table, and it seems to work. Have I missed something?

UPDATE

No i didn't do it right. The data is being written to the Joomla DB. The new table doesn't show up in the DB Save action admin - keeps saying DB Connection Failed. Yet I have all correct DB info (user, PW, etc.) Bummer

Hi jjspelman,

If it works that good.

Often when you export MySQL statements they include schema/database names or Joomla! prefixes, that need to be updated before inmporting into another database.

Bob