[linux] mysql - restore
michal_lackovic na sk.schneider-electric.com
michal_lackovic na sk.schneider-electric.com
Pátek Březen 5 09:37:18 CET 2004
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
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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)
iD8DBQFARyXKLy7GnyorcF8RAuyUAKCWxW0Mr6qbr43pGxzJp+BzOKEySQCeII42
9gQoo5dtH/KQsAoMA6LR8GQ=
=KQcS
-----END PGP SIGNATURE-----
_______________________________________________
http://lists.linux.sk/listinfo/linux
Prehladavanie archivu: http://search.lists.linux.sk
Meta FAQ: http://faq.lists.linux.sk
_______________________________________________
http://lists.linux.sk/listinfo/linux
Prehladavanie archivu: http://search.lists.linux.sk
Meta FAQ: http://faq.lists.linux.sk
_______________________________________________
http://lists.linux.sk/listinfo/linux
Prehladavanie archivu: http://search.lists.linux.sk
Meta FAQ: http://faq.lists.linux.sk
_______________________________________________
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