MYSQL database newbie

orielly has a book that is for mysql managagement and has all the functions and such in there... a section on interacting with perl, from the terminal.... and from php

isbn: 0596002114

i dont understand a single thing you said expect to get a book about MYSQL maby if i show you what i posted on other forums you migh be able to understand what im trying to say:

Quote:
hey everyone sorry but i just have to ask you the following questions:
1. What's the difference in making your own MYSQL database or using the CPANNEL to generate one?

2. i heard phpmyadmin managed MYSQL databases, can i use it to add stuff? and how (i know im not as smart as you guys)

3. My goal is to put info and pictures in a database, and retrive them using PHP

Thanks!!! sorry i can't figure this out on my own, im only 15 and i'm trying to master adobe photoshop7 at the same time.

1 - I know CPanel can make a database, but I don't remember it being able to make tables. Or even populate a database. A lot of servers who use CPanel for their hosting will only allow you to add databases to your account using CPanel.

2 - phpMyAdmin is capable of doing anything you want to mySQL. And if they don't have a fancy pancy form or GUI for a task, you can manually write a query and run it from phpMyAdmin.

3 - ok. Be prepared for a learning curve.

darnit! i was at step 3 before reading your post (2-3 days ago) and well the tutorial failed me, i got an error, any easy guide like:
http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html

because that one didn't work well

or maby you can help me out with the tutorial.

on this pagepage it says (around the 10th paraghraph)
"We're going to need that dump file I mentioned earlier"
what is that ^

ok. you're 15. you're trying ot learn a photo editing program as well as several things that require an understanding of things that you had issues with (failing pascal).

to be able ot make a database effciently you should really understand data types so you know what to use. you should also realize that unless on your own server, you'll have to deal with what a host gives you. the only thing that's garunteed is the command line.

you have a lot of time ahead of you before you need to find a job or anything like that. i suggest relaxing and finding someone offline that can teach you the computer things you need to know so be able to use a scripting language effiiently as well as interacting with a database in a command line setting.

while doing that go master adobe.

i'm not trying to attack you, but rather point out that there's a lot you don't understand. as i tried to point out in the other thread, the fact you failed pascal should not be pushed aside lightly. it is a programming language, which is much different than using a program, or writing in a markup language (example: html). with the trouble you'vebeen having, it's a good idea to step back an learn each part individually. and find someone offline to teach you php and dbs, becasue of what you told us about pascal, you probably need a higher and more customized level of guidance than you will ever be able to obtain online.

at your current level the book i suggested would be useless. it's liek it's written in alnguage you don't know. the reason is simple, you've already had issues with psacal, which means that until you find a way to relateto thsi type of thing better and convert what's read about it, you wont have the level of understanding needed.

i'm trying to be realistic. if you really want to do this, find someone offline to help you. what you seem to be seeking is a personal tutor, which is beyond the scope of any site.

o really i failed pascal now?

aren't you the one that said that you did? someone on this site recently said (s)he did

mohd said he got "a bad mark". He never said he failed. You came to that conclusion on your own, m3rajk.

Quote: the only thing that's garunteed is the command line.

Don't bet the farm. Most hosts lock down the shell and only allow you ssh access after faxing a photo ID.

Quote: i suggest relaxing and finding someone offline that can teach you the computer things you need to know so be able to use a scripting language effiiently as well as interacting with a database in a command line setting.

Offline? What's wrong with online? The Webmaster Forums was setup to provide a place for webmasters to socialize. One of the main focuses of TWF is to help people solve problems (and yes, that includes helping to learn a language).

Quote: if you really want to do this, find someone offline to help you. what you seem to be seeking is a personal tutor, which is beyond the scope of any site.

TWF is not a tutor, but we are a great asset to anyone striving to learn a langauge on their own. We will attempt to answer as many questions as we can, either from personal experience, documentation, or a reliable 3rd party source.

modh, a dump file is like an export from MS Office. It is most commonly used to back up databases, but it can also be used to copy information from one database to another (same server or across servers).

You can create a dump file using the `mysqldump` executable on the server which is running the mysql server.

The output of the `mysqldump` utility is a series of mysql INSERT statements. The output is sent to the consol (stdout) by default, but is convensionally redirected to a file (`mysqldump database_name > output_file`).

A dump can be imported into a database by simply executing it from a mysql client.
`mysql -uUser -pPass -Ddatabase < output_file`

As far as which dump file the tutorial is refering to, I don't know. I didn't read through the article.

ah, i see. well i will try to figure this out, thanks Mark

If you have specific questions and sample code, that often goes a long way to helping people pinpoint where you're going awry. Be sure to comment your code thoroughly -- even obsessively. It really does help.

alright