Uploading offline database (frm, MYD, & MYI files)

Hi Guys,

I built my site offline using xampp and have just uploaded the site to my online server and everything works fine except...

I can't figure out how to upload my database... xampp has built the database using frm, myd and myi files which i don't think is right :shocking:

So basically, I have zen cart installed on my server, my custom template is working fine.... but now I need a hand getting my database online.

Any help at all will be appreciated!

Cheers!

The MYD, MYI, etc files you mentioned are what MySQL uses to store data natively. You do not use those for migrating data from your local machine to your web host.

Instead, you should go to the phpMyAdmin application in your local XAMPP and export the database data into a file.

Next, go to your web host and make sure you have a database set up already. Then using the phpMyAdmin (or equivalent software) on your web host and import the data from the file into your host's database.

The following 2 articles from the Tutorials/FAQs should be helpful in your case.

• https://www.zen-cart.com/tutorials/index.php?article=103
• https://www.zen-cart.com/tutorials/index.php?article=100
  The following article from the Wiki might also be useful.

http://www.zen-cart.com/wiki/index.php/Server_Admin_-_Switch_Servers

Thanks for your help... I have created the database file but when I try to upload it through phpmyadmin I get this error :huh:

Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.11.7
-- http://www.phpmyadmin.net

-- Host: localhost
-- Generation Time: Nov 29, 2008 at 12:00 PM
-- Server version: 5.0.51
-- PHP Version: 4.4.8
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"

any idea what the problem could be? Cheers!

fixed it :clap:

deleted the original database and made a new one with mysql 5 instead of mysql 4 then did a fresh install of zen cart.

Everything worked fine after that!

Many thanks!
:hug: