db data import

[spottedhaggis]

Hey all.

I have an old version of Zencart

Zen Cart 1.3.0.2
Database Patch Level: 1.3.8

And a new version (upgrade and new design for site)

Zen Cart 1.3.8a
Database Patch Level: 1.3.8

On V 1.2.0.3 the database backup tool works a treat, but on the new version I get the following error message when I access the tool.

Warning: filemtime() [function.filemtime]: stat failed for /home/XXXXXX/public_html/macro/admin/backups/php.ini.bak.migration in /home/XXXXXX/public_html/macro/admin/backup_mysql.php on line 420

Warning: filesize() [function.filesize]: stat failed for /home/XXXXXX/public_html/macro/admin/backups/php.ini.bak.migration in /home/XXXXXX/public_html/macro/admin/backup_mysql.php on line 421

Then the file is shown and can be restored, also backups can stil be run

After the file listing display I then have the following.


Warning: filemtime() [function.filemtime]: stat failed for /home/XXXXXX/public_html/macro/admin/backups/php.ini.bak.migration in /home/XXXXXX/public_html/macro/admin/backup_mysql.php on line 441

I dont know if this is fixable so I have 2 quesitons

1. Can this be fixed?
2. Assuming not, can someone tell me what database parts I need to backup and restore to include the following information

All customer details, orders, products and attributes.

Basicalley everything I would need to put into a fresh store without the actual cart stuff.

[kobra]

Don't you have phpmyadmin??
https://www.zen-cart.com/tutorials/i...hp?article=103

[spottedhaggis]

Yes I do have that but this site is not going to be managed by me, and the customer wants the ability to be able to backup their database when they want to as a precaution, and they are not techy with db admin.

This does still work, just the errors make it look ugly, though on an older version of zencart 1.3.5 it works fine, exact same script?

[DrByte]

I have an old version of Zencart

Zen Cart 1.3.0.2
Database Patch Level: 1.3.8

YIKES ... you're running v1.3.0.2 code (php files) against a v1.3.8 database? Scary.

But that's not the main issue of your post.

Warning: filemtime() [function.filemtime]: stat failed for /home/XXXXXX/public_html/macro/admin/backups/php.ini.bak.migration in ...

"stat failed for xxxxxx" means the server tried to get file-detail stats (name, size, date, etc) about a certain file, but was denied access due to permissions.

The error message is happening in relation to this file:
/home/XXXXXX/public_html/macro/admin/backups/php.ini.bak.migration

And ... I have no idea why you would have such a file in *that* particular folder.

The simplest solution is to delete that file, if that's not going to cause some other sort of problem (ie: WHY was that file put there in the first place ... and, does removing it cause you some sort of other problem?)

[spottedhaggis]

This has to be something different. The old site was running the version of ZC you stated, and last week I upgraded their database to accommodate the new site I built using the 1.3.8 version, so the actual new site is fully up to date and current.

As to the php file, I checked and its not actually their?

Zen Cart 1.3.8a
Database Patch Level: 1.3.8

[DrByte]

YIKES ... you're running v1.3.0.2 code (php files) against a v1.3.8 database? Scary.

But that's not the main issue of your post.

This has to be something different. The old site was running the version of ZC you stated, and last week I upgraded their database to accommodate the new site I built using the 1.3.8 version, so the actual new site is fully up to date and current.

If it's still saying v1.3.0.2 when you look at the version details, then you've not upgraded all the PHP files correctly.

Again, that has nothing at all to do with the error message you're seeing when running the database-backup addon. I only mentioned it as an alert, to draw your attention to something that could be potentially bad in general.

[DrByte]

"stat failed for xxxxxx" means the server tried to get file-detail stats (name, size, date, etc) about a certain file, but was denied access due to permissions.

The error message is happening in relation to this file:
/home/XXXXXX/public_html/macro/admin/backups/php.ini.bak.migration

And ... I have no idea why you would have such a file in *that* particular folder.

The simplest solution is to delete that file, if that's not going to cause some other sort of problem (ie: WHY was that file put there in the first place ... and, does removing it cause you some sort of other problem?)

As to the php file, I checked and its not actually their?

Perhaps the file is hidden, and thus not viewable by you using FTP. Maybe it's visible using a file-manager provided by your hosting company's web account control panel?
Maybe you'll have to ask your hosting company for assistance in identifying the purpose of that file, and removing it if it's not necessary. The "bak" and "migration" parts of the filename suggest that maybe it was there for temporary reasons and can be safely removed?

[spottedhaggis]

I think maybe Im being missunderstood.

The old site was 1.3.5.

I then installed a fresh clean copy of 1.3.8, new database the works.

Using the backup tool from the 1.3.5 I created a db backup. Used this to populate a clean new empty database (created a ############## of the old one) then ran the db upgrade to get the database up to a level that supported the latest release of ZC.

I then directed the fresh clean 1.3.8 install to this ############## db and it worked perfectly, I was surprised, but not a single issue.

I then installed the backup tool (fresh download) and get this error.

LMAO I just found through the host cpanl, the file is their, 0bytes in size and permissions of 0000 lol, deleted the file and its all sorted now.

I had no idea files could be hidden like that? very weird, but thanks.