Problems with Mambo mysql database importing from local machine to remote server. I need someone to fix it up.
Ok, I've build Mambo site on my local server and now I want transfer this site to the remote server. All Mambo files are ftp-transfered from local to remote root and [url removed, login to view] file is adjusted to proper work on the new domain. Then, with PhpMyadmin on my local machine I exported database .sql file in txt format (small file - 900 kb). Problem appears when I want to upload that file to my remote server (also with PhpMyadmin). PhpMyadmin gives my a message: "Drop database statement is disabled". I tried all possible export and import options in PhpMyadmin (with and whitout "Add DROP TABLE" checkbox, as txt file, zip file, gz, just with txt copying...) and allways the same thing. I called my hosting provider to see what he saying about that and he sad that problem is in different MySql sever versions. On my local machine - MYsql 4.1.8 and on the remote server 4.0.25. He told me that I need manually check the stuff and create one by one table in sql .file and mos components... I've lost my patience and I post this here to find someone who can do this for reasonable price cose I dont know how. Only thing that I wannt is this - When I enter my domain address on remote server - my home page appears. I've build site locally 3 months and I wannt to see it online finally. I will send to you exported .sql file and other necessary info.
MySql local version - 4.1.8 MySql remote server - [url removed, login to view] .sql txt file size - 900 kb