Remote Database Table Copier

Well, that's all fine and dandy, but what I would really like to see is a script that creates a php object class for each table. A script that creates the layer of abstraction between the php code and the database. Has anyone seen this? I've seen it for servlets and oracle/mysql, but never for php. That's what I want...

-Ryan

Love what I see here! This solves 1 of my 2 problems and could solve the second but I would rather have more features built on top of this...

Problem 1) Mirror tables remotely from one db to another - done, thanks!

Problem 2) Do this again and again with new data.

What I really want is to run a staging / live server setup where data is entered in the db on the staging server then mirrored to the live server. For performance reasons, it would be best if the remote tables where only updated with new data the didn't already exist there. I know that this is a much more complex problem. If anyone has information / code to help or start me in the right direction, that would be great!

I tried the Table Copier script - it works GREAT, except when a table field has data type TINYINT. This field type will be translated as UNKNOWN by the script and Create table... query will fail.

Alex

You can set the script timeout at runtime in your scripts. I have some .sql dump files that I upload through phpMyAdmin that take over 2 minutes to process; the system default on my client's hosting service is 30 seconds.

http://www.php.net/manual/en/function.set-time-limit.php

Hi!

It is very frustrating not being able to print the article WITH the examples of code (green-coloured)... Such informations are most interesting and time-saving.

Must we to copy it by hand?

Thanks in advance for giving me a tip for printing the articles fully.

Sincerely,
Nicolas.

I have had the same problem for sometime. The problem started when I went to Netscape 4.7 - I also use IE 4.7 and have no problem so I assume the fault lies with Nstscape. I don't know if this applies to you.

Jerry

I was wondering how I could connect from my desktop Windows 98 computer that is running a copy of MySQL to my ISP's MySQL database.

Right now when I run the "Remote Database Table Copier" it only connects to the remote ISP's server and not my computer.

The ISP is the target computer and I have placed the "Copier" program on the ISP's website, thus they have "localhost" as their IP address. I must run it from the ISP because I cannot change my permissions. This part works and I can easily connect to the ISP's database.

However, I am not sure what to set my source IP address to for my local computer. When I try to set my source ip address of my local computer to 127.0.0.1 (generic local computer IP) it simply connects to the ISP database. I connect via a Road Runner Cable Modem, but when I type in that IP address it wont connect to my computer, also.

What should I do?

Thanks.

Pete Boyd

PS: Quite simply, I have been using the Access-ODBC to create and update my MySQL database, so that I can cut-and-paste a bunch of text. I now have a rather large database to upload to my ISP.

Online Casino Gaming is a $5b business! Start profiting from it today!

Are you a webmaster or do you own a website? Do you want to earn 25% of the
profits from the online gaming of your website visitors?

Join the CCC-Casino Referral program and get your own piece of the world's
online casino action. It's like owning your own online casino!

Here's how it works - just send an email to referral@ccc-casino.com with the
header 'join referral program'. Our support team will send you the
materials you need to get started. The registration only takes a few short
minutes, and you will be on your way to earning money with e-commerce!

Follow these four easy steps to begin profiting from online casino gaming!

1) Put the links and banners we send you into your Website or Opt-in Email
program
2) Your users click on the links, and are taken to CCC-Casino
3) Your users are added to your 'referred customer list' when they register
4) You earn 25% of the profits on their play at CCC-Casino for as long as
they stay with us!

Get started today!

· CCC-Casino gives you long-term income for a few minutes' work!
· No-download JAVA software maximizes sign-ups and your income!
· It's FREE to join!
· Online reporting is coming soon - Track your success in real-time!
· Link-specific reporting means your returns will keep getting better!

Just think - if your referred users to CCC-Casino account for just 1% of
2001's growth in online gaming, you could earn an income of $150k in 2001
alone! And since you will be paid from Antigua, your earnings are TAX-FREE*

Remember: with www.CCC-Casino.com , even when you stop working, you don't
stop earning! Email us to join now!

* Tax law in your jurisdiction may vary. It is your responsibility to
report any earnings, as required by your local tax authority. CCC-Casino
cannot report your income for you.

It is a very good useful tool for me to transfer the data from one server to another.

But I have a problem. My tables are very big. I tried and the error says maximum execution time of 30 seconds.

Is it the setting of 30 seconds in mysql or php or apache? I cannot find it. Could anybody help me?

I suggest you try to export the data and them import the data in new server.

I have create a table and inside the table got some data have ' symbol example ABS's bookshop, Chong's book. all this data cannot select by using the PHP-MYSQL, why? last time, when use cgi, this all data can select but ....

Hi
I have a problem in connecting two database. one database is reside in the server another one is reside in remote place. I like to update the remote database while updating the server database. I have no idea to connect this database. Anybody
could help me to connect two database. The exciting technology is in JAVA JSP Javabeans and Tomcat server. plz help in this topic

Sorry about that posting...
Allthough it's true what she was writing, it wasn't meant to be posted here....
rgds
albi
http://www.ccc-casino.com

Dear Friends,

I am totally new for mySQL.Present I am learning mySQL on Linux at my home PC.I am installing mySQL on RedHat Linux 7.0.
But whenever I want to connect with my username gitesh
# mysql -u gitesh -p mysql
then it will ask me to enter password.When I enter my password then it will give error like
Can't coonect to local host MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Whenever I want to try to start database through mysqld as user mysql then it will also give me error like
touch /var/run/mysqld.pid permission denied
chown /var/run/mysqld.pid no such file or directory
touch /var/lock/subsys/mysqld permission denied

Please help to solve these problems.

Thanks in advance.

Regards,
Gitesh Trivedi.

Someone downloaded PHP and mySQL on the system for me. Now I am trying to figure out how to go and create a table. There's no such thing as a command prompt for me to start working with. and I have no clue as to how I have to set up myself as a user for mySQL to run as.

Can someone please help me with:
Setting up a user
Settin up path
Running mysql_install_db , setting root password ... and so on

so that I can start getting functional.

Please help me out. Thank you!

Regards

Savitha