 |
bobw
User
Oct 27, 2006, 8:09 PM
Post #1 of 5
(469 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
(453 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  ), 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
(445 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
(444 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
|
|
| |
|
Theo
Project Manager
/ Moderator
Oct 30, 2006, 9:27 AM
Post #5 of 5
(411 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
|
|
| |
|
