help with database utility

lukeurtnowski

Somebody saaaavvveee me!
I downloaded a mysql databale utility from the internet and cant figure out what to enter in the fields,
I tried localhost as the name, root, as the user medivas1 as the password and the database name as medivas. I cant connect, why (isnt the server name localhost and the user root?) Can I check this with phpmyadmin (which connects)

leatherback

Hi,

Just a stupid question maybe but eh.. Medivas / Medivas1 are the names which you have used as passwords for the server?

lukeurtnowski

Yes (is that allright?) medivas is is the name of the database, and medivas1 is the password for the MySQL server. I'll change the password once I figure this out though.

leatherback

Hm..
Have you tried without username?

I do not know your settings. But at home I run things without username. On my live server I have a different name, but certainly not root. So perhaps you need to check how you set this up.
Localhost as servername sounds right

lukeurtnowski

ok, it also doesn't connect with no username (root). I have phpmyadmin on the mysql database, can I check it from there?
(also, do you know how to make a php file writable?)

leatherback

Yeah, you can check in the Mysql database in the phpadmin module, look in table users.

All php files should be writable. If not, use the chmod() command in your php script

lukeurtnowski

ok, im sort of new with phpmyadmin. The only user table was in the mysql database and I tried that username and password and it didn't work? (Attached). Where can I find the table users?
Thanks....

leatherback

Hi,

THat is the table I was referring to. Looks like you did inded set things up with root as user. The password is MD5() encryoted (I think) so just copying the password from there won't help you.

Have you tried whether a normal PhP script can connect to the database with the usernam,e/password settings you mentioned? If so, then the script requires some other settiungs, and you really should refer back to the site where you retrieved it.

lukeurtnowski

OK, heres the script my pages use to connect, they do connect

<?php
$hostname = "localhost";
$username = "root";
$password = "medivas1";
$database = "medivas";
$connection = mysql_connect($hostname , $username , $password)
or die(mysql_error());
$db = mysql_selectdb($database , $connection)
or die("cannot find database");
?>

the place where I got the script http://assurebackup.com/ hasn't returned my questions last week, so I figure I can figure oit out, hopefully....

leatherback

So.. eventually you are looking for a way to create a database backup then?


<?php

function get_structure($server, $user, $pass, $db)
{

mysql_connect($server, $user, $pass);
mysql_select_db($db);
$tables = mysql_list_tables($db);
while ($td = mysql_fetch_array($tables))
{
$table = $td[0];
$delete .= "DROP TABLE IF EXISTS $table;
";
$r = mysql_query("Show CREATE TABLE `$table`");
if ($r)
  {
  $insert_sql = "";
  $d = mysql_fetch_array($r);
  $d[1] .= ";";
  $SQL[] = str_replace("\n", "", $d[1]);
  $table_query = mysql_query("SELECT * FROM `$table`");
  $num_fields = mysql_num_fields($table_query);
  while ($fetch_row = mysql_fetch_array($table_query))
    {
    $insert_sql .= "INSERT INTO $table VALUES(";
    for ($n=1;$n<=$num_fields;$n++)
      {
      $m = $n - 1;
      $insert_sql .= "'".mysql_escape_string($fetch_row[$m])."', ";
      }

$insert_sql = substr($insert_sql,0,-2);
$insert_sql .= ");\n";
}

  if ($insert_sql!= "")
    {
    $SQL[] = $insert_sql;
    }
  }
}
$out = $delete.implode("\r", $SQL);
return $out;

}

  //*************************************************************
  // END OF DECLARATIONS and function definition ****************
  // ************************************************************

// We create a file
header("Content-type: application/txt");

// With date and name
$filename = "Database_backup_".date("F_j_Y").".txt";
header("Content-Disposition: attachment; filename=$filename");

// And execute the script
echo get_structure($db_host, $db_user, $db_password, $db_name);

exit();

?>

lukeurtnowski

Sorry (lunch),
Correct, I am trying to find out how I can backup my database and restore it (if I need to). I choose this program because it looks so great and no programming is required. Do you think I should use it? and (I dont mean to sound ignorant) but what is that php scriipt you sent me?

leatherback

Hi,

The script I just posted does exactly what you want: It creates a full dump of the database, in a format you can use to re-create the database, including tablestructures.

The other program..I am not sure. The fact that you cannot easilky get it to work puts me off a bit..

lukeurtnowski

thanks soo much,
All I have to do to configure it for my server is change the 4 variables in

echo get_structure($db_host, $db_user, $db_password, $db_name);
to match those of my server
Alsi, can this file be saved in a folder called backup/ in the root
And lastly, if I were to restore the database usinng thhese txt filles, would I have to use phpmyadmin (ie, can I have a script which would restore the database , so that phpmyadmin wouldn't be used??

Thanks

leatherback

Hi,

Yes. You just use the $db_host, $db_user, $db_password, $db_name for your system.

The current script I have set up to create a file to the user:

[/code]
// We create a file
header("Content-type: application/txt");

// With date and name
$filename = "Database_backup_".date("F_j_Y").".txt";
header("Content-Disposition: attachment; filename=$filename");

// And execute the script
echo get_structure($db_host, $db_user, $db_password, $db_name);

exit();
[/code]

but of course you could use the fopen function to create a new file, and write the data into that file with fwrite, I believe.

Creating a script which reads it from the server should also work.

I did not do this,. because I have it as a security against hackers too: I download the database from my site weekly, and store them locally. Thjis way, if the server is invaded, I still have clean backups.