How to load up tables and data into a database

astoller

I have mysql and mysqlCC configured and running.
My book says, to load up the winestore database type:

/usr/local/bin/mysql -uusername -ppassword < winestore.database

I dont understand this command and it does nothing.
How else could I load up to my persoanl server, a downloaded database complete with tables and data?

nnichols

In MySQL-CC open up the file winestore.database and run the query by clicking on the "run" button.

I can't be more specific coz I don't use MySQL-CC

Hope this helps 😉

statrat

the winestore.database is just an sql file (you can open it in any text editor).

you running windows? here's how i did the winestore load on my XP

put winestore.database in mysql/bin.
open command prompt and cd to there
run these commands:
C:\mysql\bin>mysqladmin create winestore
C:\mysql\bin>mysql winestore < winestore.database

or do it in mycc:
make sure your server is registered
make sure your users are configured
create winestore database
click on "sql"
open winestore.database
click the exclamation point

astoller

Statrat

When I run the command

c:\mysql\bin> mysqladmin create winestore
I get the message

"Cannot find file"

How do I make sure server is registered ?
How do I make sure users are configured ?

statrat

dude, ok.
what os are you running?
what mysql version? got the latest mysqlcc?

to do it with mysqlcc:

first, make sure MySql is up and running.

then, in mysqlcc,
click File -> New
this should open a "Register Server" window. type in anything for "Name". type in localhost for "Host Name". click "Test". if successful, click "Add".

Now under the left pane where it says "MySql Servers" you should see your server you just named. Double click your server and you should see a folder called "Databases" and two icons that say "Server Administration" and "User Administration".

now, in the toolbar you should see a button that has "SQL" on it. click that and it will open a new window. in that new window, click File -> Open and browse to the winestore.database file, select it, and click Open. (you'll probably have to change "Files of Type" to "All Files ." to be able to see the winestore.database file). now the text of that file should appear in your SQL window.
once it does, click the Exclamation Point. it'll take about 30-45 seconds to load all the data.

Go back to the Console Manager window, click the Refresh Button, and you should see the winestore database. double click it and you should see the tables under it.

Now, i just went through the whole process and it worked exactly as i told you, so if it doesn't work for you, then dude, i don't know how to help you.

astoller

Statrat

Thanks for the guidance.
It worked.

Art
UK

astoller

Statrat

I am running a script customer2.php which displays a customer form.
I am not logged in
How do I login

username as@websites.co.uk
p/w 123

When I enter details and submit I get access denied.
Where do I set up a username and password?

statrat

In MysqlCC right click on "User Administration" and create a new user:
any username
localhost
any password
Check "All Privliges"
Under "Allow Access to" check Global Privileges.
click add.

now back in winestore rename "db.dummy.inc" to "db.inc".
open that file and change the username and password values to those you just entered into mysqlcc.
that should do it. let me know.

astoller

Statrat
Thanks for suggestions.
Carried out your instructions on mysqlCC.
and understand it more now.

When I run
http://localhost/example.customer2.php
and fill in the form, it takes me to example.customer1.php and I get the error message:

Warning: Cannot send session cache limiter - headers already sent (output started at c:\program files\easyphp\www\example.customer.1.php:25) in c:\program files\easyphp\www\example.customer.1.php on line 31

Any ideas on this?
Thanks
Art

statrat

hmmm. i don't get that problem.
1. If you are using PHP on a Windows system, and if you didn't already, make sure to set the session.save_path in the php.ini to your temp directory (e.g. c:\windows\temp)...or some other directory you create\have.
2. Make sure you (or your text editor) didn't accidentaly or purposefully add any blank lines/spaces to the top of those customer files or .inc files.

astoller

session.save_path exists in windows/temp and there are recent files there.So its working.
What does the cache limiter mean?
Perhaps I should post the 2 scripts involved ?

As a reminder of the message:

Warning: Cannot send session cache limiter - headers already sent (output started at c:\program files\easyphp\www\example.customer.1.php:24) in c:\program files\easyphp\www\example.customer.1.php on line 30

Art

statrat

http://www.php.net/manual/en/ref.session.php#ini.session.cache-limiter

The cache limiter defines which cache control HTTP headers are sent to the client. These headers determine the rules by which the page content may be cached by the client and intermediate proxies. Setting the cache limiter to nocache disallows any client/proxy caching. A value of public permits caching by proxies and the client, whereas private disallows caching by proxies and permits the client to cache the contents.

you should become familiar with the manual.
you can post your scripts if you'd like.