Webmaster-Talk.com - The Database Forum

vps database backup with 0 tables?

BillBD — Fri, 20 Nov 2009 13:04:36 GMT

Hi to all
I am trying to restore vb forum from a backed DB copy by the host;
file manager in cpanel shows DB size= 2.6 G
phpmyadmin shows 0 tables for the backup db
while it shows 219 for the current working DB.

My question: how the tables are created in the backup
or how can I get the forum restored from the backup copy when it has NO tables ?

notes:
phpMyAdmin - 2.11.9.4
MySQL client version: 4.1.22
forum: running on VB 3.8.4

Regards
Bill

What is the best way to store tags in mysql?

virtualmisc — Wed, 18 Nov 2009 22:49:17 GMT

Hi
What is the best way to store tags in mysql database?
Please help me with this.
Thanks

Database structure

scoubida42 — Tue, 17 Nov 2009 22:53:59 GMT

Hi everybody!!
i must create a database for a bed and breakfast!!!!!!
- there are different types of rooms : family, double & simple
- In certains rooms, the client can smoke but not in all rooms
- there is a breakfast on a print car and clients can choose what they want
- There are different kind of menus : Vegans, vegetarians, nut allergies
- In menu, we also can find juice, coffee, tea
- Clients can order menu if there are not expensive
- For foreign clients, the passeport number must be asked
- For the booking, clients choose the type of room, type of menu
- le B&B r�compense les fid�les clients

Table Client (ClientId , FirstName, lastName, Adress, Postal Code, Country, Phone, PaiementId)
Table Room (RoomNumber, TypeRoom, Price)
Table BookingRoom(RoomNumber,CLientId, DateBeginning, DateEnd,)
Table Paiment (PaimentId, Type, Date,)
Table BreakfastList?
Table BreakfastClient?
table Price?? I am not sur

What do you think about a such database??
Do you see any problems in this structure?
anything I should have done differently?
anything I could do to improve database performance?

All comments will be appreciated!!
Thanks

error in your SQL syntax; check the manual ...

Anshuman09 — Mon, 16 Nov 2009 06:33:21 GMT

Hello:

I have recently shifted my database from one host to another. While I have managed to import all the database tables, I keep on encountering error messages - some that I could take care of and some I couldn't. Below is the example of the latter type:

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order ASC' at line 1 for query SELECT t.*, tt.* FROM tip0705_terms AS t INNER JOIN tip0705_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') AND ( t.term_id <> 9 AND t.term_id <> 1 AND t.term_id <> 3 AND t.term_id <> 5 AND t.term_id <> 6 AND t.term_id <> 7 AND t.term_id <> 8 AND t.term_id <> 10 AND t.term_id <> 12 AND t.term_id <> 13 AND t.term_id <> 14 AND t.term_id <> 15 AND t.term_id <> 16 AND t.term_id <> 17 AND t.term_id <> 18 AND t.term_id <> 22 AND t.term_id <> 23 AND t.term_id <> 24 AND t.term_id <> 28 AND t.term_id <> 29 AND t.term_id <> 30 AND t.term_id <> 31 AND t.term_id <> 32 AND t.term_id <> 33 AND t.term_id <> 34 AND t.term_id <> 35 AND t.term_id <> 36 AND t.term_id <> 40 AND t.term_id <> 41 AND t.term_id <> 42 AND t.term_id <> 43 AND t.term_id <> 44 AND t.term_id <> 45 AND t.term_id <> 46 AND t.term_id <> 47 AND t.term_id <> 48 AND t.term_id <> 53 AND t.term_id <> 54 AND t.term_id <> 55 AND t.term_id <> 58 AND t.term_id <> 62 AND t.term_id <> 63 AND t.term_id <> 64 AND t.term_id <> 65 AND t.term_id <> 66 AND t.term_id <> 67 AND t.term_id <> 68 AND t.term_id <> 69 AND t.term_id <> 70 AND t.term_id <> 74 AND t.term_id <> 77 AND t.term_id <> 79 AND t.term_id <> 80 ) ORDER BY order ASC made by require, require_once, include, get_sidebar, locate_template, load_template, require_once, wp_list_categories, get_categories, get_terms

Can you guide me as to what changes I should make in the above?

Thanks,
Anshuman

Select rows older than 3 months ( based on last used field )

lynxus — Thu, 12 Nov 2009 10:55:37 GMT

Hi Guys,

I have a lastused field, How do I select rows that are OLDER than 3 months " so i can mail the user saying, Use it or you will be deleted "

The field is a timestamp in this format 2009-11-08 12:56:31

Thanks in advance.
Graham

what are all the list aspects to concentrate in Database Optimization

varul — Wed, 11 Nov 2009 14:39:48 GMT

I want to optimize the database, which should serve for feature deployment also.
Can any webmaster tell me, how it can be done?

Problems with this design?

MagicMoose — Sat, 07 Nov 2009 20:43:03 GMT

Hi,
I'm currently working on the db design for web app. I briefly explained my ideas to someone else who said that they were unsuitable for the purpose but didn't have time to go into detail. Can anyone help me work out the problems with my approach and a better way to go about attacking the problem?

I was planning on having a 'base' table called nodes, which contained common data for every record created in the application: eg id, time created, updated. I would then like to use the id number from this table as both a foreign and primary key in other tables. I would also like to use any attribute which is shared by other models in the application as separate tables which simply contain the base id and the value of that attribute.

For example:

Base table:

Code:

id | created_at | updated_at

Page table:

Code:

base_id | content

Title Attribute table:

Code:

base_id | title

The 'Title Attribute' table could then be used to contain the titles of anything that required a title (if a title is an optional attribute, a record is simply not created in the table). For example, a diary event may require a title, and that could simply be put into the same table and linked to a different model via the foreign base id.

A simple outer join could then be used to retrieve all of the necessary information whenever needed.

It seems logical to me to share attributes between different models rather than repeating them in each table.

I realise this would require more overhead when inserting and performing select queries, but would it not also reduce redundant data, if certain properties are not required? Also, using InnoDB would enable me to remove the entire record by simply deleting the base record and using cascade.

Any advice and tips, opinions and constructive criticism will be greatly appreciated.

Thanks.

How to calculate BMI in a table

ashgirl — Tue, 03 Nov 2009 10:52:24 GMT

Hi,

I am just beginning to use Microsoft Access again and have no idea how to perform calculations in a table.
I have a table which shows a number of fields e.g. a client's age, height and weight. I would like to add a field in the table which calculates BMI using the following formula - weight (in Kilogrammes) divided by height (in metres squared)
Please please can someone help!

database problem

john_zakaria — Mon, 02 Nov 2009 12:29:57 GMT

i have a site of a Clothing store .. the local database in the store is MSSQL but the database on server is MYSQL....
i want to make instant synchronization so when someone buy a cloth from the store it will be deleted from database (MSSQL) to ensure that it is bought.. i want also to remove it from the database of phpmyadmin at the same time.. so if anyone tries to buy it from the shopping card online he will find that this product is already sold..

so i need an instant synchronization program or an y other idea between mssql and mysql so any changes in mssql will chnage the database in phpmyadmin...

mysql table - multiple information

ronnieb — Sun, 01 Nov 2009 18:37:40 GMT

Hi

I have some code made up for my oscommerce webshop

Basically its a coupons modification, but im having a problem with my database configuration.

Basically I can choose multiple products to apply a discount to
however, when it goes into the database it only stores the 1st one

how, or where do i get it to store many

this is my table

Quote:

CREATE TABLE IF NOT EXISTS `coupons` (
`coupons_id` int(10) unsigned NOT NULL auto_increment,
`coupons_code` varchar(32) NOT NULL,
`coupons_value` decimal(15,4) NOT NULL,
`product_ids` int(10) unsigned NOT NULL,
`type` varchar(32) NOT NULL,
`num_times` int(11) NOT NULL default '0',
`total_times` int(11) NOT NULL default '0',
`coupons_notice` varchar(250) NOT NULL,
`coupons_min_order` int(11) NOT NULL default '0',
`coupons_date` date default NULL,
PRIMARY KEY (`coupons_id`),
KEY `idx_code` (`coupons_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

`product_ids` int(10) unsigned NOT NULL,

is the row it goes into - how do i make take multiple numbers

Thanks

Stored Procedures Help please- simple question

badmanmc — Sun, 01 Nov 2009 06:21:40 GMT

I have made stored procedures in Oracle...but need to export them to mysql. I have searched on google but cant figure out the syntax.

Here is the oracle procedure:

create or replace procedure delgroup
(g_id in number)
is
begin
DELETE FROM grouptable WHERE GROUP_ID=g_id;
commit;
end;

I jus basically want to delete the group from the group table..depending on which group id (the arguement) the user types in.

How would i do this exact same procedure in mysql?

Please some assistance guys :)

Anyone reccommend a simple, free database system for this site?

erich1 — Sat, 31 Oct 2009 15:04:37 GMT

Take a look at www.paddlingabc.com which is an online guide to rivers in my area. In the rivers tab you will see that I have them listed alhabetically, by area, etc. Right now that information is not stored anywhere. Just in basic html. I would like to have it in a database so that users could submit rivers and have them automatically added. Any ideas on some free software I could use to do this?

Stored Procedure Hell

Ralpharama — Fri, 30 Oct 2009 11:46:49 GMT

Hello all, I just joined, and (is often the case) I have a problem perhaps someone could give me a pointer towards fixing. I've tried to keep this simple...

I have a stored procedure that has been working fine for years, but won't work on a different server, under certain circumstances. After pulling my hair out for a considerable amount of time I went back to basics and created a single, standalone page that called the SP.

Now, I get the same error everywhere and can't get this page to work at all. Perhaps someone can suggest what I'm doing wrong?

The error is:

Code:

Microsoft OLE DB Provider for SQL Server error '80040e10'

Procedure or function 'sp_CategorySearch' expects parameter '@keywords', which was not supplied.

sp_test.asp, line 20

This is the top of the stored procedure:

Code:

USE [MY_DATABASE]

GO

/****** Object:  StoredProcedure [dbo].[sp_CategorySearch]    Script Date: 10/28/2009 15:20:46 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

CREATE PROCEDURE [dbo].[sp_CategorySearch] (

    @keywords varchar(255),

    @dbfields varchar(255),

    @withinCategoryID int

) AS...etc

And this is the ASP calling page that throws the error:

Code:

<%

oDB = Null

db_username = "myusername"

db_pass = "mypassword"

db_server = "mydbserver"

db_network = "dbmssocn"

adOpenStatic = 3

Call db_connect(oDB, "MY_DATABASE")



Set cm = Server.CreateObject("ADODB.Command")

cm.ActiveConnection = oDB

cm.CommandText = "sp_CategorySearch"

cm.Parameters.Append cm.CreateParameter("@keywords", 129, &H0001, 1000)                ' 129 = adChar (string), &H0001 = adParamInput

cm.Parameters.Append cm.CreateParameter("@dbfields", 129, &H0001, 255)

cm.Parameters.Append cm.CreateParameter("@withinCategoryID", 3, &H0001)                ' 3 = adInteger (int)

cm.Parameters("@keywords") = "water"

cm.Parameters("@dbfields") = "CName"

cm.Parameters("@withinCategoryID") = 0

Set rsC = cm.Execute



db_disconnect(oDB)

%>

Where the db_connect() and dbdisconnect() are simple functions to open and close the connection.

Anyone any ideas about why this SP complains?! I'm willing to try just about anything!

normalization of events and dates

groober — Fri, 30 Oct 2009 11:38:52 GMT

I have posted the description below on the databasejournal site also.

Hi,
I have an address book database that keeps people in one table, occasions (meeting, birthday, etc) in a second table, and a lookup table, personOccasion, that signifies the occasions one is interested in with regard to a person. So, for example one may wish to know when one last had a meeting with a particular person. Following this pattern it would seem sensible to include a date field in the personOccasion table. However, what if one wants to be able to refer to a person's birthday? It would seem most logical to include date of birth as a field in the person table but doing so means that it cannot be properly reflected in the date field of the personOccasion table.
How do I get around the issue without having repeating groups in the person table?
I hope this is not too vague. Help much appreciated

Database structure for CMS

yoke.lee — Wed, 28 Oct 2009 09:52:07 GMT

Hi

I am making a CMS system for an e-shop.
The goal is client would be able to manage their own catalogue including categories and products.
I don't have any problem creating categories that has many products.
But I cant think of how to allow user configure their own product's attributes.
For example: a fashion store has color and size for their product, while others don't.

How to make the structure without duplicating the item record? all i can think of is having several records of the items with same name, price, summary, description but with different color and size (color and size column is customized, so may not be there also).

I hope everyone can understand what I'm trying to explain.
Please help me. Many thanks in advance. :)

This simple joing mysql select return many duplicate results

m_abdelfattah — Tue, 27 Oct 2009 17:39:34 GMT

I've problem with this query :
http://pastebin.com/d41a87b78 ,

It returns many duplicated results ,
here's image : http://img26.imageshack.us/i/mysqlun.jpg/

SQL Tutorials?

kcmartz — Tue, 27 Oct 2009 13:13:45 GMT

Any great mySQL tutorials??

I know this has been asked b4, but don't have the time to look for it, I am too busy... ...school, chores, homework...

Phpmyadmin and BLOB Password

Lindkvist — Mon, 26 Oct 2009 23:41:21 GMT

Hi,

I have a mysql database with access via phpmyadmin as we have forgotten the password on the encrypted BLOB, How to change password or see the current password?

Problems running Wordpress as a ABckup on Xammp

shonkyboy — Thu, 22 Oct 2009 14:56:44 GMT

Sorry the title should be Problems running Wordpress as a backup on Xammp - but i couldnt figure out how to edit that!

Hi - I have to do a bit of troubleshooting on a Wordopress site offline on my xammp inatallation so i found some articles on how to back up Wordpress files and database and install them on the local machine so i can do the editing from there.
These are the steps i took.

1.I downloaded all the files from the site via ftp.
2. Backed up the database via phpmyadmin.
3. Created a new directory for the site in the localhost xammp
4. Created a new database in xammp phpmyadmin with the same name.
5. added the user with all privalages as in the wp-config file
6. Changed all istances of the live url in the sql backup to the local one - so http://www.mydomain.com - to http://localhost/domainname
7. Imported the changed sql file into phpmyadmin in xammp

so from there the front page works ok - but a lot of the images seem to be missing. Does anyone know why this would be?
Also, if i try and put cusom permalinks %postname% - it takes me back to the xammp main page - i guess this is something to do with how xammp handles apache mod rewrite or .htaccess but im not sure why - could anyone be kind enough to shed some light on this please?
Thanks