Topic awaiting preservation: more mysql problems

man i hate this program but hey im determined to use it
i looked at some tutorials and they all say right type in mysql> -help and stuff like that but noe of them say where to type it
so i looked in the help book and it says to create a database or a table you have to right click the database bit and it just says flush hosts flush logs flush tables flush threads
and i am using a program called WinMySQLAdmin 1.4 i dont even know if the program is right someone please help

you don't actually type in mysql> -help

what oyu do is open up a DOS command prompt, navigate to your MySQL installation directory, and then into the bin, and run mysql.exe Then at the new [rompt that comes up, enter '-help' without the quotes. What you're in is MySQL's command-line back-end access program. Be careful what you do...you can inadvertantly wipe everything by entering the wrong command in the wrong context.

ok im sick of mysql now i jus cannot stand it
is there any reason for me to use mysql as opposed to more simple programs like access
im making user sections on my site

have you tried a scripted MySQL management solution like PHPMyAdmin?

One or two fairly large ones come to mind...
1- Webhosts usually run Linux - Access will not work there...
2 - Access is not free...
3 - Access chokes somewhere around 15-25 users...
4 - You get to learn how a database works...
5 - It's fast, really fast...
6 - MySQL is Open Source, Access is... Well, part of the Microsoft Office package...

; ) /Dan

{cell 260}
-{ a vibration is a movement that doesn't know which way to go }-

I have alot of experience with access databases, and have just started using mySQL - i dont have enough experience to judge mysql yet however.

With access, i have not as yet encountered any problems - but it depends entirely what you are doing. There are plenty of hosts out there with windows servers, and from what i have seen they are increasing (ive even seen hosts without linux servers at all T.T)..

If you are doing a simple database for a backend of a website, access does work fine, i have found the speed is also fine for the average product database with say 500 products etc, keep in mind this can be hard to evaluate when you are testing your site and are the only person accessing it..

While access is not free, most people run office anyhow and have it installed - so it is very easy to just download the database and have a look through it, i havnt had enough time to play with mysql yet so im not sure if you can do this, or if you need to install something on a server to run the database.

I have done some offline projects where access has benefited me, particularly with an offline CMS - since there is only 1 user speed is not an issue, you could even create a mySQL from this to upload to the webserver if required.

I dont regret starting with access at all, BUT only because off my offline uses. If you are only using databases for online then i would go straight with mySQL. If its easy enough to setup a server with it also, then i would probably start going that way offline as well.

...

So.. having said all of that - which is only my experience with access, i would still lean towards mySQL. Like DMS said you have to remember mySQL is open source which is always damn handy, its portable between linux and windows servers, and alegedly its fast - if DMS says it is, then i beleive it . .....

-----------------------------------------

On your first post

quote:

---

mysql> -help

---

I beleive (but am not at all sure) that these commands are done when you telnet into your server and connect to the database? I have seen alot of these and i think thats how you create databases etc, without running from a script.

-----------------------------------------

Back onto mySQL databases, DMS how portable are they? For my host i think the only wa to create a mySQL database was through the admin panel, and i beleive this creates the database on the server hard drive somewhere inaccessible directly by me. Can you use phpmyadmin or something to actually get these files? Im guessing there has to be a way since people would have to transfer the db to a new server from time to time.

Also is it possible to access the table files directly or do u have to create the database layer and name the database to access everything? (Im guessing this is the bit you mean about 'you get to learn how a database works'..


eckk.. sorry for the long post mySQL gets me excited

Well, I wouldn't consider myself a db-guru in any way, but I do know fairly well how to use them in a web-context-

This:
mysql> use
and so on is indeed things you write at the command prompt to work with mysql.be it linux or windows. Basically they work the same.

"how portable are they"
Well it depends on what you mean with portable.
A database is physically a set of files on the server that the db-engine works with.

I'm developing on Win and deploy to Linux all the time and from one windows box to another you can in fact create the database on one machine, then copy the files inside the folders in the "C:\mysql\data" folder to the other one. That's your databases.

BUT, even if that works, it's not the way to do it.
(And no, you can't as far as I know work directly with the databasefiles without using the mysql-functions. It's not really plain-text. What you call the "table files" doesn't exist until you have created the database and the tables.)

Learing to use the commad prompt is always very good since different hosts provide different ways to manage the db.

Then you have ton's of graphical interfaces to MySQL, from "PHPMyAdmin" which is a set of php-pages that allows you to work with the data/database to full blown applications for windows/linux/mac that gives you the interface.

Personally I use MySQLManager from http://ems-hitech.com/mymanager/ which I thing is superb. A free trial is available.

I've also used an old app called "MySQL Front" that worked pretty well (the latest version I don't like at all).

Then you have SQLyog from http://www.webyog.com/sqlyog/index.php also good.
DBdesigner from fabforce is also cool, slightly buggy but still: http://www.fabforce.net/dbdesigner4/

For Mac a decent one is http://cocoamysql.sourceforge.net/ not a favourite but the best i've found yet

All of these apps will in different ways allow you to connect to databases, either locally on your machine or over the net through IP if your host allows it.

Through this functionality you can connect to two databses at the same time and move/copy data from one to another. Another way is to export the database (with or without data) as an SQL-file that holds the sql commands to recreate the database and insert all the data in it on another dbserver.
This is usually how you backup your database.
Seen from this respect it is very portable.
If the recieving database can read and support the exported SQL (datatypes and such) it's portabel between different database engines as well.

Now, this is not special to MySQL, this is actually basically how Access and all the others work as well. You store the data in the filesystem using a structure that the end user can define himself, the database-engine indexes this data and offers different interfaces to work with the data.

/Dan

{cell 260}
-{ a vibration is a movement that doesn't know which way to go }-

my admin control panels for MySQL can export the database, it structure and content, to a text file, complete with the MySQL commands ready to add it back in if need be. I certainly know PHPMyAdmin can.

This looks like a perfect candidte for the SSS forum to me...

color me blind, but... aren't we in the SSS forum right now...


/D

{cell 260}
-{ a vibration is a movement that doesn't know which way to go }-

Yep we are, but we weren't before I moved the thread here... =)

I know that all those new ranks can be confusing, though - as a ML I'm now one of those who can clean the Sink and archive/preserve/move threads around.

kuckus

Ok cool, access was just slightly different as you access the mdb file directly and u just copy it like any other file to move it. But you can create a named database the same as mysql i believe.

Uhh just out of interest...

I just loaded phpmyadmin on one of my shared hosting domains... is it normal that i can see everyones databases on the shared server? I mean i can see other peoples in the list, how can u restrict people getting to your database, just password it?



Also....
I can see i can do an SQL dump of the data, or export to csv etc..... but i see no import option? So if i wanted to put this database on a new server is there a way to create a new mysql database with the sql dump?

(Edited by H][RO on 08-03-2004 04:39)

ummm...no...that's not normal. At least I don't think it is. What it means is that your host hasn't removed the default localhost:root:no_password account from MySQL...and this is a big security risk for everyone on the server.

And yes, there is a way to import, what oyu do is create your database, then go to the 'sql' tab, then load up your SQL file and it will run the actions therein

Ok thanks, i think i will send a message to my host !!

ARgg.. they are trying to figure it out... i can still see everyones database, and even if i set a password user for my database i can still get onto it without a password/user.

Is there anyway to set the blank login/password to something?