[linux] mysql - restore
krym
krym na paranoia.sk
Pátek Březen 5 11:20:16 CET 2004
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
resource OK znamena, ze is_resource($res) vrati true, takze je slnena
podmienka, ze je upsesne pripojeny, takze ta nula znamena, ze mysql_errno
vrati nulu , co znamena, ze za dvojbodkov nemas nic, lebo mysql_error ti
vrati nic.
teraz si daj
mysql_select_db("databaza");
a skus nejaku query
Dňa Pi 5. Marec 2004 11:02 michal_lackovic na sk.schneider-electric.com napísal:
> vyhodilo to
> az sem to prislo :-/<?php
>
> potom som tam pridal mysql_errno
>
> $res = mysql_connect("localhost", "rot", "");
> print is_resource($res) ? "resource OK\n" : "zlihal som\n";
> echo mysql_errno($res) . ": " . mysql_error($res). "\n";
> print "az sem to prislo\n";
>
> ?>
> a vyhodilo to
> resource OK 0: az sem to prislo
>
> pritom uzivatel rot neexistuje
>
> miso
>
>
>
>
>
>
> krym <krym na paranoia.sk>
> Sent by: linux-admin na lists.linux.sk
> 05.03.2004 10:18
> Please respond to linux
>
>
> To: linux na lists.linux.sk
> cc:
> Subject: Re: [linux] mysql - restore
>
>
> este skus takuto primitivnu vec:
> <?php
>
> $res = mysql_connect("localhost", "root", "");
> print is_resource($res) ? "resource OK\n" : "zlihal som\n";
> print "az sem to prislo\n";
>
> ?>
>
>
> to znamena, ze aj keby ti nenapisal chybu, tak ak sa pripoji, vytvori
> resource
> ak nie, tak nevytvori a ak ti vypise "az sem to prislo", tak ti skript
> neseklo. je to stupidne, ale mozno ti to pomoze
>
>
> Dňa Pi 5. Marec 2004 09:33 michal_lackovic na sk.schneider-electric.com
>
> napísal:
> > Zdravim, nahodil som cely slackware na novo
> >
> > takze:
> > v httpd.conf mam :
> >
> > # PACKAGES REQUIRED: openssl-solibs (A series) and/or openssl (N
>
> series),
>
> > # mysql (AP series), gmp (L series), and apache (N
> > series)
> > #
> > Include /etc/apache/mod_php.conf
> >
> > php teda funguje.
> >
> > v php.ini mam:
> >
> > error_reporting = E_ALL
> >
> > cize mal by som vidiet vsetky chyby
> >
> > httpd a mysql bezia
> >
> > 040305 09:18:07 mysqld started
> > 040305 9:18:10 InnoDB: Started
> > /usr/libexec/mysqld: ready for connections.
> > Version: '4.0.15a' socket: '/var/run/mysql/mysql.sock' port: 3306
> >
> >
> > Fri Mar 5 09:18:11 2004] [warn] module mod_php4.c is already added,
> > skipping
> > [Fri Mar 5 09:18:12 2004] [notice] Apache/1.3.28 (Unix) PHP/4.3.3
> > configured -- resuming normal operations
> > [Fri Mar 5 09:18:12 2004] [notice] Accept mutex: sysvsem (Default:
> > sysvsem)
> >
> >
> > urobim php skript
> > pricom uzivatel apache neexistuje, takze by som cakal ze to vyhodi aspon
> > nejaku chybu,ale ono nic...biela stranka
> > <?php
> > mysql_connect("localhost", "apache", "");
> > print mysql_error();
> > mysql_close();
> > ?>
> >
> > phpinfo vykazuje ze php je skompilovany s mysql
> >
> > verzia php: 4.3.3.
> > mysql 4.0.15a
> >
> > miso
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > michal_lackovic na sk.schneider-electric.com
> > Sent by: linux-admin na lists.linux.sk
> > 05.03.2004 08:09
> > Please respond to linux
> >
> >
> > To: linux na lists.linux.sk
> > cc:
> > Subject: RE: [linux] mysql - restore
> >
> >
> > ahojte,
> > tu je vystup z phpinfo
> >
> >
> > MySQL Support
> > enabled
> > Active Persistent Links
> > 0
> > Active Links
> > 0
> > Client API version
> > 4.0.15a
> > MYSQL_MODULE_TYPE
> > external
> > MYSQL_SOCKET
> > /var/run/mysql/mysql.sock
> > MYSQL_INCLUDE
> > -I/usr/include/mysql
> > MYSQL_LIBS
> > -L/usr/lib -lmysqlclient
> >
> >
> > Directive
> > Local Value
> > Master Value
> > mysql.allow_persistent
> > On
> > On
> > mysql.connect_timeout
> > 60
> > 60
> > mysql.default_host
> > no value
> > no value
> > mysql.default_password
> > no value
> > no value
> > mysql.default_port
> > no value
> > no value
> > mysql.default_socket
> > no value
> > no value
> > mysql.default_user
> > no value
> > no value
> > mysql.max_links
> > Unlimited
> > Unlimited
> > mysql.max_persistent
> > Unlimited
> > Unlimited
> > mysql.trace_mode
> > Off
> > Off
> >
> > miso
> >
> >
> >
> >
> > Toth Michal <Michal.Toth na st.fm.uniba.sk>
> > Sent by: linux-admin na lists.linux.sk
> > 04.03.2004 14:33
> > Please respond to linux
> >
> >
> > To: "'linux na lists.linux.sk'" <linux na lists.linux.sk>
> > cc:
> > Subject: RE: [linux] mysql - restore
> >
> >
> > staci ten user, pod ktorym sa pripajas k db , t.j. ten ktoreho
> > specifikujes
> > pri volani mysql_connect() - davaj si bacha na to ci sa konektujes cez
> > socket alebo cez loopback, myslim, ze v jednom potom treba localhost a v
> > druhom bud pravu ip adresu, alebo loopback adresu (to len tak na okraj,
> > keby
> > to blblo).
> >
> > miso
> >
> > -----Original Message-----
> > From: michal_lackovic na sk.schneider-electric.com
> > [mailto:michal_lackovic na sk.schneider-electric.com]
> > Sent: Thursday, March 04, 2004 2:15 PM
> > To: linux na lists.linux.sk
> > Subject: Re: [linux] mysql - restore
> >
> >
> > 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)
iD8DBQFASFQqLy7GnyorcF8RAnQ5AJ9gLt4qY0D0H6bGZy2n/G47xM3oNACeKRRl
3T2XAM34Qkt3VoEt34O7EAs=
=nsGY
-----END PGP SIGNATURE-----
Další informace o konferenci linux