Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Discontinued/Classic Products: Article Manager 2:
Question - conversion to mysql database

 
 


bobw
User

Oct 27, 2006, 8:09 PM

Post #1 of 5 (1020 views)
Shortcut
Question - conversion to mysql database Can't Post
I have a question - If I start a site using AM2, but do not use the mysql database option, is it possible, if the site becomes too large, to convert to the mysql format in the future without losing data?


Theo
Project Manager / Moderator


Oct 28, 2006, 10:25 AM

Post #2 of 5 (1004 views)
Shortcut
Re: [bobw] Question - conversion to mysql database [In reply to] Can't Post
Thanks for posting, BobW. You can definitely do that - moving data to different databases is an important function of the software. It's done in Admin > Database Editor under "Database Actions".

The process is very smooth, and even if the process is interrupted for some reason (server goes down, you're attacked by ninja Wink), you shouldn't have any data loss.

You'll even be able to go back to flatfile again later, if necessary, in case you're moving web hosts.

Hope that helps! Let me know if you have any questions.


Theo Wiersma
Project Manager

(This post was edited by Theo on Oct 28, 2006, 10:29 AM)


svsanchez
User

Oct 28, 2006, 1:14 PM

Post #3 of 5 (996 views)
Shortcut
Re: [Theo] Question - conversion to mysql database [In reply to] Can't Post
Hello Bob, I am stuck in the conversion process, I don't know what to put in the following fields:

DATABASE NAME
USERNAME
PASSWORD

Do I have to go to MySQL and create a new Database and User first "by hand" or is there another step that I am missing which does this automatically?


Damon
Staff / Moderator


Oct 28, 2006, 1:26 PM

Post #4 of 5 (995 views)
Shortcut
Re: [svsanchez] Question - conversion to mysql database [In reply to] Can't Post
Hi,

Before converting from a flatfile database to MySQL, you need to create a database for Article Manager on your web server. Your hosting provider can offer assistance with this.

After you have created a database on your web server, here is the fields you'll need to fill out are:

Hostname: Check with your hosting provider. Sometimes this is localhost (but not always).
Port: Leave this blank unless your hosting provider has specified a non-standard port.
Database Name: This is whatever name you chose when you created the database.
Username: The username of the MySQL user you created with access to the database.
Password: The password for your MySQL user.
Table Prefix: This will prefix all of the table names, and helps you keep all of the tables separate from any other program you might have using the same database. It's recommended to use something like "artman_" or "am_".

I hope that helps. :) Let us know if you have any other questions.

--------------------------------------------------- 
Cheers
Damon Edis
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/


Theo
Project Manager / Moderator


Oct 30, 2006, 9:27 AM

Post #5 of 5 (962 views)
Shortcut
Re: [svsanchez] Question - conversion to mysql database [In reply to] Can't Post
Note that you don't necessarily need to create a new mySQL database - you can use an existing one if you want, the table prefix makes sure there are no collisions. Article Manager also checks to make sure that it's not overwriting any existing tables.


Theo Wiersma
Project Manager