I have 2 eccomerce sites that have almost identical product databases. I want to host the product tables in a separate database for the 2 eccommerce sites to share. I tried connecting to 2 separate databases at once, but couldnt…
I have 2 different servers: one running Plesk Panel (PHP 5.2.13 & MySQL 5.0.45-community-nt), and the other running Zend Server 5.5 (PHP 5.2.17 & MySQL 5.1.50-community). I have a table in mysql DB on both servers as follows: CREATE TABLE…
1st query; both tables contain all categories_ids SELECT * FROM categories c, categories_description cd WHERE c.categories_id = cd.categories_id ORDER BY sort_order, cd.categories_name 2nd query; this table maybe hold a categories_id SELECT count(*) AS total FROM products_to_categories WHERE categories_id = "'+…
first the details of the configuration: openSUSE 11.3 with Parallels Plesk Panel 10 (64-bit) Server MySQL installed and running (no "skip-networking") java 1.6.0_24 (Java HotSpot(TM) 64-Bit Server VM (build 19.1-b02, mixed mode)) The mysql server listens on 0.0.0.0:3306 netstat -lnp…
MySQL error: Failed to Connect to MySQL at 12.34.567.890:3306 with user jsdbadmin Lost connection to MySQL server at 'reading initial communication packet', system error: 61 Using: Plesk, SuSE vServer, fresh installation: completly new about an half year ago. Software: Trying…
I have a database full of data looking like this ΑντικαταβολΠand I need to find a way to convert it all into proper, utf8 data. Is there a way to do it? The db is MySQL and is from…
I have a database called apsc and if I run SHOW TABLES; on it, these are the results: mysql> show tables; +------------------------------------+ | Tables_in_apsc | +------------------------------------+ | aps_application | | aps_application_backup | | aps_application_resource | | aps_package | | aps_package_configuration…
I had used .mdb for my ASP applications. Since I've learned and used php, I, now, want to use ASP applications with MySql databases. However, I get some errors that I cannot figure out. This is my code: set conn=server.createobject("ADODB.Connection")…
We are building a large scale e-comm web site to service over 100,000 users, but we expect the number of users to grow rapidly over the first year. In general, the site functions very much like ebay where users can…
I am trying to optimize the following modified MySQL query from OsCommerce: select distinct p.products_id, pd.products_name, m.manufacturers_name, s.specials_new_products_price from products p inner join products_description pd on p.products_id = pd.products_id inner join products_to_categories p2c on p.products_id = p2c.products_id left join manufacturers…