Okay I have a database in MYSQL 5 and I recently got Asmallorange and they are using MYSQL 4.1. Will my database be affected in any way?
Before heading up with the MYSQL dump please make sure that, MySQL 4.1 does not support stored routines or triggers. If your databases contain stored routines or triggers, prevent them from being dumped when you use mysqldump by using the --skip-routines and --skip-triggers options and also MySQL 4.1 does not support views. If your databases contain views, remove them with DROP VIEW before using mysqldump
Sorry, I'm very new on MYSQL and webhosting. What is the "Shell"?
Also what do routines/triggers, and compatible options do? I recently uploaded my database (vbulletin forum) to my MYSQL 4.1 server (from MYSQL 5 on my windows server) and it works fine, though I haven't thoroughly checked whats missing.
What are somethings that vBulletin can do in MYSQL 5 against MYSQL 4.1?
If you're using vBulletin, you're not using views, triggers, or stored procedures. No PHP scripts out there that I know of offhand are using any of those. You can safely export the database out to import into our servers.
Former owner of A Small Orange New owner of <COMING SOON>