SQL migration to server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MYSCREENNAMEISUNAVAILABLE - 22 Jan 2008 15:13 GMT

1. I must completely thank all of you on this forum, especially The
FeldKirscher, (and David Powers' book - PHP5 for Flash) for helping getting
this project to work!

2.After a long and hard road, I finally completed a flash 8 (AS 2.0) that uses
the netdrims component/Netdrims php file, to load one mySQL database, use it,
and then save new information to 4 different tables in that database.

3. This was proven to work on my local, offline PC using mySQL 5.x, Apache,
php 5.x, and myPHPAdmin.

4. As this is my first time, I want to upload the mySQL database, html, and
swf files to my server.

(i.e. migration of completed flash,php,SQL project from localhost to server)

5.The host of my Linux server runs appropriate versions of Apache, mySQL, php.

6. What considerations are important?
Do I need to change the component path from localhost to something else?
How do I set up the root password to the mySQL database on the server, etc.

In short, what parameters that I set up in the flash component/mySQL, Flash,
that I got to work on my PC as localhost do I need to change to get the same
project to work on my web server?

Thanks.

Reply to this Message

The Feldkircher - 23 Jan 2008 12:08 GMT

I appreciate your kind words, thanks

Has for uploading to your public site, then localhost should be the same you
can check this with your ISP.

Upload all files to your Server with the same stucture as you have them
locally. That means all folders, files, html, images, swf's in your local
htdocs folder for this project should uploaded.

It maybe necessary to create folders inside the public_html folder and then
copy the appropriate items into them.

With mySQL be very carefull not to overwrite all delete any exsisting
databases or tables, its advisable to make a complete backup of MySQL then if
anything goes wrong with your install then you can at least put it back as it
was.

I will look for instructions how to migrate, perhaps someone else may help in
the interim period.

Ciao For Now

Reply to this Message

MYSCREENNAMEISUNAVAILABLE - 25 Jan 2008 13:18 GMT

After contacting my web host, I found out the following about migrating to
their server:

1. I'm allowed only 5 mySQL databases which each can contain many tables (UNIX
server). Each database must use my username-sequential (1-5).
2. Because of the database limitation, I have to re-structure my database to
accomodate different tables instead of different databases.
3. I have a daily kb limit of SQL queries (my current is 256kb) without
upgrading my plan (more $$)
4. I keep localhost but must setup a mySQL password/username on the server. I
do NOT use root as the mySQL username.

Now I'm in the process of rewriting my flash AS2.0 and mySQL databases to
accomodate their requirements.

Reply to this Message

MYSCREENNAMEISUNAVAILABLE - 29 Jan 2008 04:59 GMT

I've:
1. created a duplicate mySQL database on my server
2. I using a run-time AS to state the filepath to the netdrims php script:
flashSQL.filepath
="http://4themax.com/education/regents_quest/flashsql_0606le.php"

which on my localhost was in htdocs/webdev

3. I'm sending the appropriate database name, hostpassword, and mySQL
username, and password via the
(does NOT use root for mySQL username)

flashSQL.Execute("SELECT * FROM "+_global.testselection+"_question_keys",
_global.database, _global.host, _global.mySQLusername, _global.mySQLpassword,
"", "", "");
//This line instructcs FlashSQL to run the query, load the data

3. This is the page that's supposed to load the data when I click:

http://www.4themax.com/education/regents_quest/quiz-home.html

nothing happens

Any advice about the filepath for the netdrims php file?

Reply to this Message

The Feldkircher - 08 Feb 2008 22:01 GMT

Hi

I have found a desktop app that allows you to administor mysql, one of the
features inside allows you to transfer local databases to remote locations.

Here's the link:
http://www.webyog.com/en/download_final.php?url=http%3A%2F%2Fwww.webyog.com%2Fdo
wnloads%2FSQLyog615.exe

Download - Install - Enter MySql Login info and your ready to roll.

Hope it helps

Reply to this Message

MYSCREENNAMEISUNAVAILABLE - 25 Feb 2008 02:38 GMT

The documentation that comes with the Netdrims (now Flexcubed) flashSql
component states "the php server file must be in the web root directory, for
example c:\www\website" which is a bit confusing for newbies like myself.
Netdrims is now run or owned, I think, by Isaac Coker. The flexcubed.com
website is incomplete and so is their tech support despite my offer to pay him.
While Isaac occasionally answers emails when he's not doing other projects, he
leaves the user hanging and and has little experience in guiding newbies into
eliciting the appropriate info and action so he can help them. He may be an
excellent programmer/developer, but the company really needs to get their
support act together if they want to publically sell their product on adobe.com

all that said, if the server php file is put into the website's root folder
where the index.html file is on the server, then the php filepath is found
by the netdrims component as in:

flashsql.filepath = http://www.4themax.com/flashsql_v31.php

now my problem is that although the mySQL database is connected, the component
doesn't load the records into an array like it did on my offline server.

anyone else out there use this component before?

Reply to this Message

luisbraga05@gmail.com - 29 Mar 2008 01:30 GMT

On Feb 25, 2:38 am, "MYSCREENNAMEISUNAVAILABLE" <ak...@4themax.com>
wrote:

> The documentation that comes with the Netdrims (now Flexcubed) flashSql
> component states "the php server file must be in the web root directory, for
[quoted text clipped - 17 lines]
>
> anyone else out there use this component before?

Any luck with the problem? I've bougth v4 and I can't get it working
online, just in my local mamp (wamp for os x)server...

Reply to this Message

Webmaster Forum / Flash / Data Integration / March 2008

SQL migration to server