[linux] mysql - restore
michal_lackovic na sk.schneider-electric.com
michal_lackovic na sk.schneider-electric.com
Pátek Březen 5 11:06:18 CET 2004
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
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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)
iD8DBQFASEX1Ly7GnyorcF8RArXUAJ4hFCFIUFDJGNGQDqf95nAzf/5wsgCeKf6V
1tsB83aeH9UdWlBpHf7TIUU=
=Z7qG
-----END PGP SIGNATURE-----
_______________________________________________
http://lists.linux.sk/listinfo/linux
Prehladavanie archivu: http://search.lists.linux.sk
Meta FAQ: http://faq.lists.linux.sk
Další informace o konferenci linux