Lost products in Database

In Local Database using MAMP, All products are not there. I am able to use Products_Insert to add new products, and Product_Search, alt F12 hit search button to change the new products. The remote Database has all of the products and I edited them there. Would like to see them also back at local. I did synchronize remote Database to local and did not see the products.

What am I not doing? Also, This happened after I Put file from local to testing server when I was offline and MAMP was on, but I had no wireless signal. Local Database still had users in there and they were not erased or disappeared. Looks like MAMP is creating a new database, Which I cannot use since I need the old one back and the new one created deleted. I did back-up the Remote Database and then used that back-up to synchronize to local.

site: californianatural.net.previewdns.com/

This is code on Products_Search page that only allows me to add and create a new database.

<p align="center" class="MsoNormal" style="margin: 0in 0in 0pt; font-family: 'Trebuchet MS', Arial, Helvetica, sans-serif;">&nbsp;</p>
<p align="center" class="MsoNormal" style="margin: 0in 0in 0pt; color: #060;">&nbsp;</p>
</blockquote>
<div class="WADASearchContainer">
<form action="products_Results.php" method="get" name="WADASearchForm" id="WADASearchForm">
<div class="WADAHeader">Search</div>
<div class="WADAHorizLine"><img src="WA_DataAssist/images/_tx_.gif" alt="" height="1" width="1" border="0" /></div>
<table class="WADADataTable" cellpadding="0" cellspacing="0" border="0">
<tr>
<th class="WADADataTableHeader">Name:</th>
<td class="WADADataTableCell"><input type="text" name="S_ProductName" id="S_ProductName" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Category:</th>
<td class="WADADataTableCell">
<select name="S_ProductCategoryID" id="S_ProductCategoryID">
<option value="">Choose a category</option>
<?php
do {
?>
<option value="<?php echo $row_WADADynListproductcategories['CategoryID']?>"><?php echo $row_WADADynListproductcategories['CategoryName']?></option>
<?php
} while ($row_WADADynListproductcategories = mysql_fetch_assoc($WADADynListproductcategories));
$rows = mysql_num_rows($WADADynListproductcategories);
if($rows > 0) {
mysql_data_seek($WADADynListproductcategories, 0);
$row_WADADynListproductcategories = mysql_fetch_assoc($WADADynListproductcategories);
}
?>

Thanx, Cathy

in the SQL File that is exported, look for a line like this:

CREATE DATABASE IF NOT EXISTS remote_database_name;

where "remote_database_name" is the name of the remote database


change that to:

USE local_database_name;

where "local_database_name" is the name of your local database.

What I do see is this: I changed

Host: Localhost Database: mysql

And My changes did not work. I do not see exactly the CREATE part... and USE part or anything with "_" underscore....

CODE
-- MySQL dump 10.10
--
-- Host: host server Database: says name on remote
-- ------------------------------------------------------
-- Server version 5.0.91-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

please send the full my sql dump file

Sent you the zip file attached I deleted file, Thread is resolved....

at the beginning of this dump, add a line to force it to use the database you want to use:

USE databaseName;

where databaseName is the name of your database.

Thanx Jason - Your suggestion did not work. However, I found a way to import from MAMP and the Dreamweaver database from remote to local.... Pleawse close this ticket and delete file since my complete database was on this zip