EasyCFM.COM - The ColdFusion Community! About Us!

New Member
Posts: 13
Joined: Oct 2004

This is a good question from Growly that I would like to cover here. It's directions on how to install the "ipostmx.sql" file.

INSTALLING THE IPOSTMX.SQL FILE:

If you're using MySQL on a Windows platform, the easiest way to do this is to download the MySQL Administrator for http://www.mysql.com/products/administrator/ . There's a download link to the right called "download binaries and source". Once you successfully install the administrator and get it up and running, there is an option to "restore". Click on "restore" and near the bottom is another button titled "Open Backup file". Once you click on that, you can browse your harddrive for the ipostmx.sql file. In the target schema, type in "ipostmx" without the quotes and click "Start Restore" at the bottom.

That's pretty much it for the Windows platform. For those of you running CFMX on a Linux box, I've never used the MySQL Administrator so I'm not sure that it works the same. I would imagine that they didn't make it too different than the Windows version.

Of course, this can also be done by command line. However, that seems to be pointless and more work than necessary when MySQL has such a great administrator.

Hope that helps, let me know if you have any problems.

GrowlyBear

12-01-2004 @ 10:15 AM

Moderator
Posts: 1314
Joined: May 2004

Lovely!!! But just for interest sake. I could not wait for the answer so I converted the .sql file to .cfm . I guess that this is an option. As many people who will want to use this are virtually hosted. ( like this cute furry lil bear, not counting my home test server) So no access to the admin or having their host run the file for them.

~~~~~~~~~~~~~~~~~~~
There is no place like 127.0.0.1

This message was edited by GrowlyBear on 12-1-04 @ 10:33 AM

ColeBarksdale

12-01-2004 @ 10:26 AM

New Member
Posts: 13
Joined: Oct 2004

Funny, I was just working on a setup for those who are being hosted and don't have access to the server or administrator.

I have a problem with assuming that everyone has an environment like mine - that's a bad, bad developer flaw - sorry. Anyway, once I get something out there for those of you who are on hosted environments, I'll release it and post a message here.

e996sh

01-20-2005 @ 9:35 AM

New Member
Posts: 49
Joined: Mar 2004

ColeBarksdale,

Nice looking forum application however it is not linux/unix compatible due to the querys all being in caps. Linux is case sensitive so I get a table not found error.

ColeBarksdale

01-20-2005 @ 4:14 PM

New Member
Posts: 13
Joined: Oct 2004

On the contrary. You downloaded it from a Linux machine. The tables in my db are in all caps, so the query follows. When you used the SQL file to build the DB, did it not create tables in all caps?

e996sh

01-20-2005 @ 4:21 PM

New Member
Posts: 49
Joined: Mar 2004

I downloaded the files on my windows machine. Unziped them. Ftp'ed the files to the server. Created the database via phpmyadmin using the sql file.

The tables are all lower case in the database.

ColeBarksdale

01-20-2005 @ 4:27 PM

New Member
Posts: 13
Joined: Oct 2004

My apologies. You're right. I just checked the SQL file and all of the table names had been converted to lower-case.

We can do this a few ways. Either I can email you the correct SQL file, or you can download it from my site, or if you have a text editor, just go through and upper-case all of the table names.

Either way, I'll put up the correct file on my website as an update for iPost.

Again, sorry about the inconvenience.

http://www.colebarksdale.com

e996sh

01-20-2005 @ 6:04 PM

New Member
Posts: 49
Joined: Mar 2004

Thank you for your help. I will download the file when I get a chance.

arclight

03-28-2005 @ 2:54 PM

New Member
Posts: 7
Joined: Mar 2005

Variable LOOPINDEX is undefined.

This error is displayed when clicking on Active Discussions link.

-Sean-

ColeBarksdale

04-13-2005 @ 11:50 AM