[linux] mysql - restore

krym krym na paranoia.sk
Pátek Březen 5 11:27:18 CET 2004


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

zle som si precital, moja chyba

takze, vytvori resource, aj ked su udaje zadane zle, aspon uz vies, ze sa ti 
pripoji na mysql server
teraz daj:
mysql_select_db("databaza");
print mysql_error();

a teraz ti to vrati access denied for user rot na ............

je to presne to, co si chcel vediet, ci ti to funguje. takze ano, funguje ti 
to


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)

iD8DBQFASFXZLy7GnyorcF8RAlspAKCLgUN5h2O19NcQa26gwSeG0G8gqACfVXLM
IGOw0ueudvTQ4tCY6clMKeU=
=TPkd
-----END PGP SIGNATURE-----




Další informace o konferenci linux