Hello. the purpose of my efforts right now are to get a larger script of mine (which the admin told me he'd put into cron for me) to properly back-up my MySQL database. To test out the sql back-up part (before getting the whole script into cron, and having it not work) I wanted to test it. So here's what I did:
PHP file to do my testing (on the live server)
Script being called by the PHP
just for testing, both these files were set to 777 on the server. The output from the PHP file looks just as it should, but then I find the ./sql_backups/ directory empty. I tried the username, password and database of the last line of that script in both capital letters and lower case (read somewhere that capitals works better.. anyways). I'm not experienced with php/mysql.. I found the syntax for that mysqldump line in an article.
Hello everyone!
First I would like to say that I am very glad that I found this forum, and by some of the posts I have viewed, I see that I can learn a lot from you all!
Secondly, I know next to nothing about Linux/Unix (gotta learn sometime right?) and need some assistance.
I am a... (5 Replies)
how do i install php & mysql with apache on suse linux ???
apache was installed and configured when i installed linux.
all its files are in different folders. e.g http files in usr/local/httpd/htdocs/ and its configs are in etc/httpd/
so how do i install php and get it to work with apache and... (4 Replies)
How do i get php to sort the times in a table and print order desending. eg:
in the table i have: 02:60.00
02:70.00
02:20.00
02:50.00
in that order in a table
how do i get php & mysql to print... (1 Reply)
Hi all,
I want to restore DB file in many mysql servers, i already using script for sending the dumpfile in all servers, but it's just annoying if i have to restore the dumpfile in all servers, i want just execute 1 script, and will restore in all remote mysql servers. I make script but not... (2 Replies)
Hi folks
I have mysql dump which having insert queries, i want to break that file when 10 complete "INSERTS" lines so extract that line and store in 1.sql and 2.sql and for next 10 insert lines.
pls guide me how can i do that.
Regards,
Bash (2 Replies)
Hi all,
What I was looking for before was a multi-user password manager, web-based! The offer of free or cheap tools of this kind is very pover. Or they are too complex (or too expensive)
I'm not a web programmer but I now decided to set up a (php) website with login and based on this login... (1 Reply)
Hi, I hope the title does not scare people to look into this thread but it describes roughly what I'm trying to do. I need a solution in PHP.
I'm a programming beginner, so it might be that the approach to solve this, might be easier to solve with an other approach of someone else, so if you... (0 Replies)
I have a script (below) which works ok, but I have tried to modify it as I want to keep the older files for a restore if needed. I have tried adding a date suffix to the newly created files (second lump of code), but it doesn't seem to work.
I get the error:
$SOURCEDIR/p1db_$DATEVAR.sql:... (3 Replies)
Hi, i have the following:
db="create database xxx;GRANT ALL PRIVILEGES ON xxx.* TO user@localhost IDENTIFIED BY 'password';FLUSH PRIVILEGES;quit;"
mysql -u root -p$mysql_pass -e "$db"
I don't understand why this is failing, it works fine when run from cmd but when is run in a bash script,... (1 Reply)
Discussion started by: ktm
1 Replies
LEARN ABOUT PHP
pdo_mysql-dsn
PDO_MYSQL-DSN(3) 1 PDO_MYSQL-DSN(3)PDO_MYSQL DSN - Connecting to MySQL databases
The PDO_MYSQL Data Source Name (DSN) is composed of the following elements:
o DSN prefix
- The DSN prefix is mysql:.
o host - The hostname on which the database server resides.
o port - The port number where the database server is listening.
o dbname - The name of the database.
o unix_socket - The MySQL Unix socket (shouldn't be used with host or port).
o charset - The character set. See the character set concepts documentation for more information. Prior to PHP 5.3.6, this element
was silently ignored. The same behaviour can be partly replicated with the PDO::MYSQL_ATTR_INIT_COMMAND driver option, as the fol-
lowing example shows.
Warning
The method in the below example can only be used with character sets that share the same lower 7 bit representation as
ASCII, such as ISO-8859-1 and UTF-8. Users using character sets that have different representations (such as UTF-16 or Big5)
must use the charset option provided in PHP 5.3.6 and later versions.
Example #1
Setting the connection character set to UTF-8 prior to PHP 5.3.6
<?php
$dsn = 'mysql:host=localhost;dbname=testdb';
$username = 'username';
$password = 'password';
$options = array(
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
);
$dbh = new PDO($dsn, $username, $password, $options);
?>
+--------+-----------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+-----------------------------------------------+
| 5.3.6 | |
| | |
| | Prior to version 5.3.6, charset was ignored. |
| | |
+--------+-----------------------------------------------+
Example #2
PDO_MYSQL DSN examples
The following example shows a PDO_MYSQL DSN for connecting to MySQL databases:
mysql:host=localhost;dbname=testdb
mysql:host=localhost;port=3307;dbname=testdb
mysql:unix_socket=/tmp/mysql.sock;dbname=testdb
Note
Unix only:
When the host name is set to "localhost", then the connection to the server is made thru a domain socket. If PDO_MYSQL is compiled
against libmysqlclient then the location of the socket file is at libmysqlclient's compiled in location. If PDO_MYSQL is compiled
against mysqlnd a default socket can be set thru the pdo_mysql.default_socket setting.
PHP Documentation Group PDO_MYSQL-DSN(3)