[linux] mysql - restore

[krym]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

no jasne :)
blbo sa pripajas, 
> mysql_connect("localhost");
> user = "apache";
> password = "";

tvoj skript pravdepodobne hned skonci na parse error :)

pouzi
mysql_connect ("localhost", "apache", "");

pripadne 

$user = "apache";
$password = "";
mysql_connect("localhost", $user, $password);

predpokladam, ze v php.ini vypnute error_reporting

(direktiva error_reporting = E_ALL atd.....)


Dňa Št 4. Marec 2004 15:33 michal_lackovic na sk.schneider-electric.com napísal:
> Som z toho zufaly
>
> mam v mysql vytvoreneho uzivatela apache na localhost ma vsetky prava na
> vstup do databaz
> a stale nic, uplne kasle na mna, neda mi ziaden vystup ,ziaden debug
> proste nic..len bielu obrazovku.
>
> na test pouzivam tento kod:
>
> pre>
>
> <h3>Press RELOAD to add a record to the MySQL database:</h3>
>
> <?
>
> //establish user connection
>
> mysql_connect("localhost");
> user = "apache";
> password = "";
>
> print mysql_error();
>
> //open up database
>
> mysql_create_db("referencie");
> print mysql_error();
>
> mysql_select_db("test");
> print mysql_error();
>
> //create table
>
> mysql_query("CREATE TABLE referencie (firstName VARCHAR(25), lastName
> VARCHAR(25))");
> print mysql_error();
>
> mysql_query ("INSERT INTO referencie (firstName, lastName) VALUES ('John',
> 'Tester')");
> print mysql_error();
>
> //display the information
>
> $result = mysql_query ("SELECT * FROM referencie");
>
> while($row = mysql_fetch_array($result))
>
> {
>
> print ("Added record: " . $row["firstName"]."
> ".$row["lastName"]."<br>\n");
>
> }
>
> //close user connection
>
> mysql_close();
>
> ?>
>
> </pre>
>
> miso
>
>
>
>
>
> krym <krym na paranoia.sk>
> Sent by: linux-admin na lists.linux.sk
> 04.03.2004 14:47
> Please respond to linux
>
>
>         To:     linux na lists.linux.sk
>         cc:
>         Subject:        Re: [linux] mysql - restore
>
>
> uzivatela, pod ktorym bezi apache nepotrebujes definovat takmer v ziadnom
> pripade.
>
> ked si das print mysql_error() pod mysql_connect pripadne mysql_query, to
> ti
> povie viac, ako mailinglist
>
> Dňa Št 4. Marec 2004 14:14 michal_lackovic na sk.schneider-electric.com
>
> napísal:
> > potrebujem v mzsql definovat aj uzivatela pod ktorym bezi apache alebo
>
> sa
>
> > tento uzivatel definuje iba v php kode?
> > miso
> >
> >
> >
> >
> >
> > krym <krym na paranoia.sk>
> > Sent by: linux-admin na lists.linux.sk
> > 04.03.2004 13:49
> > Please respond to linux
> >
> >
> >         To:     linux na lists.linux.sk
> >         cc:
> >         Subject:        Re: [linux] mysql - restore
> >
> >
> > tak si zapni mysql klienta
> > mysql>show tables;
> >
> > ti ukaze, ktore tabulky mas v current database. ak ich tam mas, tak sa
> > najskor
> > pozri na tvoju webstranku, ci tam mas ako dbhost strceny tvoj aktualny
> > host/
> > usera/databazu.
> > pripadne si pod niektoru mysql_query() strc mysql_error();
> >
> > Dňa Št 4. Marec 2004 13:02 michal_lackovic na sk.schneider-electric.com
> >
> > napísal:
> > > ahoj,
> > > presne toto urobim, vsetko sa vytvori ale ked otvorim webstranku tak
>
> sa
>
> > mi
> >
> > > tam tie data nepripoja.
> > >
> > >
> > >
> > >
> > >
> > > krym <krym na paranoia.sk>
> > > Sent by: linux-admin na lists.linux.sk
> > > 04.03.2004 12:53
> > > Please respond to linux
> > >
> > >
> > >         To:     linux na lists.linux.sk
> > >         cc:
> > >         Subject:        Re: [linux] mysql - restore
> > >
> > >
> > > normalne si vytvoris cez create database novadatabaza (mysql; create
> > > database
> > > novadatabaza;\q)
> > > potom len cez shell
> > > mysql -u user novadatabaza < struktura
> > > mysql -u user novadatabaza < data
> > >
> > > Dňa Št 4. Marec 2004 10:54 michal_lackovic na sk.schneider-electric.com
> > >
> > > napísal:
> > > > Zdravim,
> > > >
> > > > zazalohoval som si mysql databazu prikazom
> > > > mysqldump --tab=/var/bck  --opt autinfo
> > > >
> > > > Ziskal som tak dva subory jeden obsahuje strukturu a druhy
>
> data.Chcem
>
> > > tuto
> > >
> > > > databazu restornut na druhej masine ale neviem ako vytvorit databazu
>
> s
>
> > > > tychto dvoch suborov.
> > > >
> > > > miso
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > http://lists.linux.sk/listinfo/linux
> > > > Prehladavanie archivu: http://search.lists.linux.sk
> > > > Meta FAQ: http://faq.lists.linux.sk

- -- 
- --------------------
http://www.paranoia.sk/
http://paranoity.sk/

fingerprint: C43D 0B69 B288 CD25 C48E D561 2F2E C69F 2A2B 705F
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAR1ZCLy7GnyorcF8RAhxvAJ400iEER2K+ZOKcmO0uIISOtmFA3gCfXmxE
p3sXPS+u/HzY9U8m+dqd3LE=
=6hkU
-----END PGP SIGNATURE-----