server migration, MySQL problem

[yessir]

I just migrated an up-to-date LAMP/Zencart system to a new server and am wondering if I might get some help. Here what the client browser sees when navigating to the Zencart index page:

1017 Can't find file: './zencart/configuration.frm' (errno: 13)
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

And here is what is reported by rsyslog:

Jan 23 09:53:34 black mysqld: 100123 9:53:34 [ERROR] /usr/sbin/mysqld: Can't find file: './zencart/configuration.frm' (errno: 13)

An attempt to migrate an image from RAID0 to RAID1 failed, so some files and directories from the old image were copied to a fresh installation (latest Ubuntu Server, LAMP, and phpMyAdmin). I would imagine that I overlooked some file(s) or directory that should have been copied. I can see the Zencart database with phpMyAdmin, but get the message "No tables found in database." I do have an extensive list of files in /var/lib/mysql, from "admin.MYD" to zones_to_geo_zones.MYI."

Any help would be greatly appreciated, as this is quite over my head.

[kobra]

Is this server self managed or managed by your peovider?

[yessir]

It is my server, running Ubuntu Server 9.10, mysql Ver 14.14 Distrib 5.1.37, for debian-linux-gnu (x86_64), and PHP 5.2.10-2ubuntu6.4 with Suhosin-Patch 0.9.7 (cli). I suspect that either MySQL is looking for files that I forgot to migrate or perhaps a file permission issue.

[DrByte]

It is very dangerous to migrate a database via the .myX files instead of doing proper export/import of the data.

So, yes, your hunch that you've missed certain files, is correct.

The proper way to migrate a Zen Cart site from one server to another is documented here: https://www.zen-cart.com/tutorials/i...hp?article=100
However, that assumes the servers are functional.
If you're recovering from a disaster, you'll need to manually recover data/files and reconstruct them into the exact same filesystem and software versions as you took them from.
For specific help on recovering a webserver (which is outside the scope of just Zen Cart), you may find focused help on a website such as webhostingtalk.com

[yessir]

My server is "functional," running the same versions of the LAMP stack on the same OS. It is serving pages, with php working on the main directory of my website. The problems begin when the client navigates to "catalog/index.php." DrByte's first recommended link instructs the user to ftp a "a fresh NEW install." But since I have the all of the partitions imaged to a drive which is installed in the new server, I am inclined to copy files and directories from the command line to the new RAID volume on which the new OS is running and avoid, if possible, the tedious process of a fresh install. I do appreciate all suggestions here and the fact that this forum is not intended to address all web server issues. I just thought I might start here.

[DrByte]

MySQL stores its database tables in a collection of files in a prescribed folder. Your server's my.cnf file denotes where those files are kept. Each table is comprised of 3-5, or more, files such as *.frm, *.myd, *.myi, etc. If your mirroring process or rsync or whatever has not properly copied all such files over, or if one or more of those files is damaged and cannot be copied, then you have a data corruption problem, and will have to take corrective action.
The simplest corrective action would be to restore from a functional backup. More specifically, restoring via an import from a properly exported copy of the data and structure of the given table.

I referenced the FAQ in my previous post because it specifically advises to use export/import of the database as part of the process of moving from one server to another.
Regular frequent backups should be part of your regular daily/weekly/monthly routines of business recordkeeping and safeguarding.

[kobra]

I am inclined to copy files and directories from the command line to the new RAID volume on which the new OS is running and avoid, if possible, the tedious process of a fresh install.

This is not a correct way to manage a mysql DB - Files yes...

From CMD and with a proper DB backup

mysql databasename < backup.sql

[yessir]

After several hours of learning about MySQL and PHP, I finally stumbled upon the solution. By enterind the MySQL root data directory, invoking "chmod -R 777 zencart," and restarting the server, the site is now completely restored. Any previous advice regarding proper database backup has been taken to heart. Thanks!

[luisitolozano]

Hi i need some help, after i migrate to a new host mi template layou is not showing and logo with any template only buttoms products and text are visible i tink is something with css but i try to reinstall another template and keeps the same

http://www . c l e a n i n g p r . com/btobid.com/marine/

[Vger]

Hi i need some help, after i migrate to a new host mi template layou is not showing and logo with any template only buttoms products and text are visible

That has nothing to do with this thread. Please start your own thread in the correct forum.

Vger