Preserved Topic: MySQL to InterBase 6 SQL Database

Ok, I am currently running MySQL on my current server, but I got a nice cheap deal on moving over to a different server, and that one runs InterBase 6 SQL Database and I want to transport the DB over. I have PHPmyAdmin on the curent server, is there anyways to transfer, with minimul changes beeing needed?

What about code? Is there a place at PHP.net where I could find this? I have not checked that yet, but I have not found anything on moving the DB's over.

Any help or links would be greatly appreciated.

-mage-

Giving the tech one hell of a hard time, but overall not going to be using the other DB, but will install MySQL instead, the wonders of having a cheap dedicated.

Oh, BTW, rackshack.net dedicated servers for 99.99

-mage-

Poke the "View dump (schema) of database" button on phpMyAdmin with "Structure and data" radio button selected.

If you don't mind shoveling your data across the Internet you could set up the new as a slave of the old. I'd go the first route.

Edit: how dedicated is your server? Can you build a custom kernel? 'Cause if you start beating that MySQL hard you could run out of file descriptors. What OS? (Don't even think about telling me you signed up for NT.) Give us more details, man. How connected is this server? Spill.



[This message has been edited by linear (edited 06-15-2001).]

I believe up to 12 virtual domains. I am not the owner, I just use one of the domains. 150 gig/month, $3.50 over. I guess it is not as unlimited as the first lead me to believe with their "Never worry about bandwidth again"

They are running Cobalt Linux. Ha, NT... can't stand that shite. I get complete control, as admin, su to root and all, controll the apach, plus get the nice cobalt admin GUI via HTTP. I can install nearly everything I need.

Didn't really have to worry about the Dump, figured that out. It was setting up the MySQL package that got me, don't work the *nix systems often, I normally just desing the code, the software is already there, but it was a good learning experience.

Also learned, not to do a PHPmyAdmin dump in a file that contains html special characters... at least when using ; as a seperating value... trashed the entire database that way... at least I had the backup...

So the host, I like it a lot... it doesn't cost me a dime, except for the work that I put into to help out the friend who used most of the bandwidth... supports everything... ASP/PHP/InterBase/MySQL/Perl... and on and on. I like it a bit. And really have no reason not to since it hosts a site I make some spare change with, and costs me nothing



-mage-

Hmmm. I've heard Cobalt Linux and MySQL don't play nice together. Don't have any first hand experience on that--I'm a FreeBSD guy myself.

Run fstat now and then to see how your file descriptors are holding up. Maybe you'll need a custom kernel. Maybe not.

DNS gets fully transfered in 7h so... we will see how they play. I have never used FreeBSD, I have heard it is nice. I am thinking of getting a second box so that I can play with a number of different opperating systems... maybe FreeBSD will be one of the ones I play with, I have been hearing a lot about its total stability lately.

-mage-

From what i've heard, FreeBSD's main selling point is its speeeed.....

FreeBSD is derived from 4.4BSD, which contains the reference implementation of TCP/IP.

That's enough reason to want to run your server on it right there. All the other good stuff is gravy.

It's free, very stable, easy to install, comes with a dynamite ports collection (5,260 programs available), has a friendly, knowledgeable user community, is extremely stable, supports lots of spiffy hardware (ATA-100 drives, USB, CD-R) that Linux may not, has a Linux binary compatibilty mode for those apps that aren't ported, has high quality security features, allows significant kernel tuning much more easily than Linux, runs X quite nicely (including all the latest window managers), and, yes, it's fast.

Says FreeBSD has much more HW support than most of the other *nix types... going to check my configs on my other box to see if they mesh, if so I may have to go do an install.

-mage-

Hey, if I can run it on my laptop, chances are any beige box you've got lying around will be supported.