database and mysqldiff question

[judoka]

Hi Everyone,
I am trying to upgrade my website from max1.7 to RC3 but before doing that I am working on it on my local computer before working on my live site. So far I have downloaded a copy of my active database onto my computer, so that I can use mysqldiff on it in order to convert my database to the new RC3 database. But I have a couple of questions that I am hoping someone can help me out with.

1) When I try to import the live copy of my database onto my phpmyadmin on my local computer it starts to import and than it stops and I get the folowing error mesage;

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1038478 bytes) in C:\wamp\phpmyadmin\libraries\import\sql.php on line 213

I looked at my sql.php file line 213 and this is what I have;


}
// Skip last char
$i++;
// Next query part will start here
$start_pos = $i;
// Aren't we at the end?
if ($i == $len) {
$i--;
} else {
continue;

I am not a coder so I don't know what needs to be change here. The size of my downloaded database copy is 1.08 MB in the zip format and 6.67 MB when I unzip it. I did do a side by side comparison of my live database and my imported copy and I notice that on some of the tables the records size are a little off but also the last six tables are missing from my local copy. Which brings me to my first questions is there any way to fix this problem? I quess I am more concern with the missing tables than I am with the record size differance, though I sure would like to keep all my records if possible.

2) My second question has to do with the mysqldiff program. When doing the convertion which is the source Database (current datebase) and which is the target database (database layout to convert to)? This may be a dumb questions but since this is my first time doing this, I just want to be sure before I make any mistake. If I understand this correctly the source database would be the copy I made of my active site and the target would be the database I made when I install RC3 on my local computer. Is this correct or is it the other way around?

Thanks guys for any and all help.

[judoka]

Hi guys, I'm still waiting on a reply to the above questions. In the meantime I decided to play around with this on my own and now I have a new question. After I ran mysqldiff and it does the convertion I am getting the following error message when I click on the send bottom:

Warning: require_once(config.inc.php) [function.require-once]: failed to open stream: No such file or directory in C:\wamp\www\mysqldiff-1.5.0\send.php on line 17

Fatal error: require_once() [function.require]: Failed opening required 'config.inc.php' (include_path='.;C:\php5\pear') in C:\wamp\www\mysqldiff-1.5.0\send.php on line 17

and no changes are made to my target database. Could someone tell me what this means and how can I correct this problem? Thanks guys

[michael_s]

You need to allocate more ram in php.ini. Set the allowed memory for php to 64 megabytes instead of 8:

memory_limit = 64M

[judoka]

Thanks Michael I'll give that a try and get back to you.

[judoka]

Hi Michael, That didn't work, I am still getting the following error message:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1038478 bytes) in C:\wamp\phpmyadmin\libraries\import\sql.php on line 213

[michael_s]

Did you restart apache? Did you edit all the php.ini files? There may be several.

[judoka]

Hi Michael, ok that worked thank you. I was able to import the whole file with no missing tables. Now I need to figure out how to query the sql file that I got from mysqldiff? I've try a few times already and it didn't work, I kept getting different error messages with each effort. I'll post back with my results after I try a few more times.

[judoka]

Hi Michael,

Sorry to keep brothering you with this but I am still having problems getting going. I was able to successfully import the sql file that mysqldiff generated to my live database copy on my local computer. I than was able to import my live database copy to this copy. But now I can not open my catalog or admin I keep getting the following error;

"Internet Explorer cannot display the webpage"

I know that my Wampserver is working because I have a second catalog with the original blank database attach to it and it opens fine. So I try to run the RC3 install again to see if this would fix the problem and RC3 will than open but all the inform in my database is gone. So I try to import my live database copy back on and again I can see my database inform like the catagories, product etc. but again I can not open my RC3 catalog and I again get the following message;

"Internet Explorer cannot display the webpage"

Could you please tell me what am I doing wrong? I believe That it may be a database address problem but when I change it on my config file I get the following error mesage;

"1146 - Table 'giftttny_xxxxxxxxx.cache' doesn't exist

DELETE FROM cache WHERE cache_expires <= '2007-12-03 07:26:51'"

and I'm not sure how to fix this problem either. Any help would be greatly appreciated.