Advertisement

11.22.2007 at 11:01AM PST, ID: 22977973
[x]
Attachment Details

mysql dump - changing Upper case to lower case on move?

Asked by Mathiau in MySQL, PHP for Windows, PHP and Databases

Tags: mysql, case, upper

Hello! Me Again, have a new thing stumping me.....


we have 2 MySQL systems, a mysql dump is used, coded in PHP to copy data from one server to another server, now when this script was running, it used to copy from Windows to a LInux system, now the LInux system is being replaced temp, with a Windows box, now switching the script to point to this new server when it runs, when it creates the folder on the new windows box, it makes the folder name with a small letter as opposed to a capital (the original soure has a capital A)

Here is the script being used, is there somethign in it thatis making it change the Capital A to a small A? or is this some new setting / restriction in MySQL 5.0.45?

This file is run via a .bat file using php.exe, something that will remain for now so i need to figure out why it is making a small A, i could manually change it every day this run, but would prefer if it could fully work.

Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:

<?
	$windows2=mysql_connect("****************","********","********");
	$windows=mysql_connect("****************","********","********");
	$dbwbases=mysql_query("show databases", $windows);
	$dblbases=mysql_query("show databases",$windows2);
	$windows2bases=array();
	$windowsbases=array();
	while ($lbases=mysql_fetch_row($dblbases))
	{	
		array_push($windows2bases,$lbases[0]);
	
	}
	
	while ($wbases=mysql_fetch_row($dbwbases))
	{
		
		if (($wbases[0]<>"mysql") and ($wbases[0]>'Archive-2005-11-28-04-31'))
		{
			
			//$Archivename=substr($wbases[0],0,7).substr($wbases[0],8,4).substr($wbases[0],13,2).substr($wbases[0],16,2).substr($wbases[0],19,2).substr($wbases[0],22,2).substr($wbases[0],25,2);
			$Archivename="A";
			$Archivename.=substr($wbases[0],1,6).substr($wbases[0],8,4).substr($wbases[0],13,2).substr($wbases[0],16,2).substr($wbases[0],19,2).substr($wbases[0],22,2).substr($wbases[0],25,2);
			array_push($windowsbases,$Archivename);
			if (!in_array($Archivename,$windows2bases))
			{
				
				mysql_query("create database $Archivename",$windows2);
				print("Moving $wbases[0] to $Archivename...");
				exec("mysqldump --opt -h **************** -u ******** $wbases[0] | mysql --host=**************** --user=******** -C $Archivename");
				print("Complete\n");
			
				
			}
		}
	
	
	}
	/* $diffbases=array_diff($windows2bases,$windowsbases);
	foreach ($diffbases as $d)
	{
	
		mysql_query("drop database $d");
		print("Dropping $d....\n");
	
	} */
	$db_list = mysql_list_dbs($windows2);
	while ($database=mysql_fetch_object($db_list))
	{
		$dbase=$database->Database;
		if (strlen($dbase)>18)
			{$realdbase=$dbase;} 
			//get the latest Archive name
	}
	//exec("mysqldump --opt -h **************** --user=******** $realdbase | mysql --host=**************** --user=outside -C ********");
?>
[+][-]11.22.2007 at 07:32PM PST, ID: 20337214

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.22.2007 at 07:34PM PST, ID: 20337219

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MySQL, PHP for Windows, PHP and Databases
Tags: mysql, case, upper
Sign Up Now!
Solution Provided By: imitchie
Participating Experts: 1
Solution Grade: A
 
 
[+][-]11.22.2007 at 08:50PM PST, ID: 20337367

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.22.2007 at 09:03PM PST, ID: 20337396

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628