I'm transferring my databases to my new server (or trying!).

I have been given the following code to use:

mysqldump -uuser -ppass --compatible=mysql40 db > db.sql

However, I can't get it to work. Could somebody please insert examples into this so I can see how to do it?

Thanks

heres a code that will loop through your database and write a .sql file into where the script is with the contents. May take a while for larger databases though -.-

PHP Code:

    $q = @mysql_query("SHOW tables");
    $sql = "";
    while($qa = @mysql_fetch_array($q)){
        $ai = false;
        $pri = "";
        $p = "";
        $qa = $qa['0'];
        $sql .= "

-- 
-- Table structure for table `".$qa."`
-- 

CREATE TABLE `".$qa."` (";
        $d = @mysql_query("SHOW COLUMNS FROM `".$qa."`");
        while($s = @mysql_fetch_array($d)){
            if($s['NULL']==""){
                $s['2'] = "NOT NULL";
            }else{
                $s['2'] = "NULL";
            }
            $s['1'] = str_replace(" ","",$s['1']);
            if(strtolower($s['5']) != "auto_increment" && $s['1'] != 'text'){$s['4'] = " default '".$s['4']."'";}
            $s['5'] = str_replace(" ","",$s['5']);
            if(!empty($s['5'])){ $s['5'] = " ".$s['5'];}
            $l = 2;
            $sql .= "
    `".$s['0']."` ".$s['1']." ".$s['2'].$s['4'].strtolower($s['5']).","; 
            if($s['3']=="PRI"){
                $pri = "
    PRIMARY KEY (`".$s['0']."`)";
                $p = $s['0'];
            }
            if(strstr($s['5'],"auto_increment")){
                $ai = true;
            }
        }
        if(!empty($pri)){
        $sql .= $pri;
        }else{
            $sql = substr($sql,0,strlen($sql)-1);
        }
        $sql .="
) TYPE=MyISAM";
        if($ai == true){
            $j = "SELECT `id`
            FROM `".$qa."`
            ORDER BY `".$p."` DESC
            LIMIT 0,1";
            $j = @mysql_fetch_array(@mysql_query($j));
            $sql.= " AUTO_INCREMENT=".($j[$p]+1)."";
        }
        $sql .= ";

-- 
-- Dumping data for table `".$qa."`
-- 

";
        $r = @mysql_query("SELECT `*`
        FROM `".$qa."`");
        while($b = @mysql_fetch_array($r)){
            $sql.="
    INSERT INTO `".$qa."` VALUES(";
            $d = @array_values($b);
            for($i = 0; $i < count($d); $i+=2){
                @mysql_escape_string($sql.= '"'.$d[$i].'",');
            }
            $sql = substr($sql,0,strlen($sql)-1);
            $sql .= ");";
        }
    }
    $f = @fopen(getcwd()."backup.sql","w");
    @fwrite($f,$sql);
    @fclose($f);
    if(!$f){
    ?>Error writing Backup SQL.<br /><br /><?
    
    }

That does work - I use it myself... Slightly messy code but I was just bothered about getting it made at the time.

that should work harvey. Did you change the pass and user to your own username and password? Are you running it from an SSH command line?

If you have phpMyAdmin installed, you could use that. Or if you are using a control panel such as cPanel, there may be a backup option for you in there as well.