i have been trying to start up my own designing business. i have run into a few problems, there are a few things that i dont know. i specialize in zen cart eccomerce designs. i know the script pretty well inside and out. os commerce is a little different, i have not customized os commerce for anybody yet, but i have played around with the script, and find it just as easy. now what i do not know. i have no idea about SQL databases. i have had a few clients want me to design for them, but when it comes to installing the script on there site, i am expected to do this, but i have no idea how. please tell me if i am going about this all wrong. i know that the program fantastico is not that loved by all. i have my own website here, which i will show you as some of my work www.mundis-boutique.com and www.mundis-boutique.com/demo3 which is not a live store, just to host templates, through my hosting company, i am given tons of space, unlimitted just about everything. so what i have been doing is installing scripts on my server, designing them for my clients, so they can see it done before i even sell it to them, but the problem is, that they usuall dont know how to install, so i guess i am suppose to, but i dont know how, because fantastico does it all for me. i have tried installing some of these things with out fantastico and it all seems like greek to me. i do this very cheap. i do webdesigning for $10 usd. this is because of my lack of knowledge on SQL. i do let my customers know this ahead of time. i am finding that they agree to installing it because they have no idea what it even means, and they expect me to show them, but i dont know either. so what i have tried doing, is going through my hosting company, and using a reseller package, offer designing and hosting(so i know i can install the script for them through fantastico) but most of my clients want to use there own hosting company, and when i try to explain to them why they need to go through mine in order for me to design for them, they back off and figure that i have no idea what i am doing, which isnt really true. so besides learning the SQL( because i have tried several times) does any body have any advice for me to get this going. BTW i have tried to find a "partner" that knows SQL and databases, ect... but nobody is interested, atleast i have not found anybody that is. so if any body is interested int hat, PLEEEEASE let me know. any ideas, suggesstions are very helpful, even if it is" just find a day job" because i am very close to giving up, but i really enjoy doing this, so i do not want to! please help, thanx in advance
regards
MUNDI

I'm confused. You mean you have scripts up and running on your server, with databases setup by fantastico, but then you have difficulty getting it setup when you move it to your clients server?

If the databases are in mysql, you could use the mysqldump utility (provided with mysql) to dump out the database structure (and contents if you wish) to a file. This creates a file containing the SQL statements necessary to rebuild the database. You can then rebuild the database on another server by routing the text file straight into mysql:

On your server:

prompt> mysqldump -d -u user -p > file.sql

The -d flag is for 'no data' which will dump the database structure but not the contents.

on their server:

prompt> mysql -u user -p < file.sql

This will create the database structure needed by the scripts.

Is that what you were after?

I'm not able to figure out what you are asking, but your price for web design is super..
Oscommerce is a kick *** package though, It is quite fun once you get he hang of it.
One of the things you might want to do when copying the databases is talk to the host
and just move the mysql files, it allows you to go around a lot of the pains of mysql.
mysqldump will mess up code eventually, especially between versions of mysql

thanx for the replies, that is what i needed help with. i understand, but now ortel, you have worried me about doing it. see, everyone may not use cpanel, or whatever. i need to know how to pretty much do a database on any server for anyone, maybe i dont know what i am talking about because i do not know anythihng about it. i know everyone does not have cpanel, i know everyone does not have fantastico, ( i must sound like an idiot!) so if i were to install zencart-os for anybody, can i use the my sql file for everyone? sorry, i have never used anything else beside cpanel and fantastico. i have bought some books on this, there yet to arrive, i will talk to my hosting company, but half the time they dont know what they are talking about! thank you guys, i think getting me to understand this would be impossible.