Steps Before Setting Up Your Mysql Backup
[quote]MySQL databases increasingly power production applications - whether these be web based collaboration tools or CRM applications. A well thought through backup plan and configuration will go a long way to ensure that you can recover your database - when a system or user error deletes important data stored in MySQL - without impacting your business. [b]1) How fast and how easy do you want the MySQL Recovery process to be?[/b] Just like planning any other backup implementation, th
How do i restore a sql.gz file? Im confused
Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always learned ONE table... put EVERYTHING in one database table. I'm making a profile system so there needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two together? I could probably figure this out faster if someone explained and posted sample SQL code that shows how the two are linked together. Thanks!! [N]F
I exported an Access database to csv file, and then imported the csv file to mysql. Now I'm trying to use COUNT() on a field, but its returning the total number of records, which is not what I want. I know that COUNT() is supposed to count all records that arent Null, so I checked out my table in phpmyadmin and I realized that even though there are no values for some records they are not showing up as Null. What is the difference between a Null and a field that is just empty? Shouldn't
Selling A Custom Ms Database Program?
I designed a custom ms database program for distributors Do any one know of a place where you can try and sell it? To a programmer or maby to a company?
Well i use to backup my website daily basic . Its help me to take care of my forum data with out any probs. Well some tools i use is named bellow. You gyes can take a look at this. [quote]*1* SQLBackupAndFTP :-(a little introduction from their website):- SQLBackupAndFTP is [b]MS SQL Server backup software[/b] that runs scheduled backups (full, differential or transaction log) of [i]SQL Server[/i] or [i]SQL Server Express[/i] databases (any version), runs file/folder backup, [b]zips[/
It is good practice to use multiple tables to sort out big amounts of data. But once you do that it becomes increasingly hard to cross reference the tables. Mysql has a little beautiful command structure that they have added. You can select multiple tables within one sql query. Example of a basic sql query [code]$sql = "SELECT * FROM table WHERE row=1";[/code] If you noticed that I selected all of the rows in the table. Normally you will try to not select the entire table from the d
Error In Installing MySQL Server
I try to upgrade my MySQL server from 4.018 to 4.1.10a. Firstly, I downloaded mysql-4.1.10a (not the essential one) for win XP Then I install the new version after the old version was uninstalled. After the installation process, Instance Configurator comes up to help for the configuration. But an error occured when it try to start the MySQL service. Error messageis "cannot create windows service for MySQL. Error:0" So my MySQL server cannot be started. It is running win XP on my com
Actually I'm relatively new to SYBASE database. Though I have worked before with Oracle, MS SQL and MYSQL, I'm finding some problems in performance tuming in SYBASE. Basically I'm dealing with very huge system with tables having 4crore + records. I have a table in which I face deadlock situation between a select statement and an insert statement. (This particular table doesn't have much records, usually <5000 records). The code piece looks like this.(Obviously
What Does Pd Pa Mean In Sql Query?
I have no knowledge about sql but I need to run a query. I found an example which get exactly output formate that I want. I plan to borrow this query script but it's very difficult to understand the code, especially, the pd, pa part, What does pd, pa mean in this code? [code] $query = <<<QUERY SELECT DISTINCT(u.ID), u.user_email, u.user_nicename, u.display_name, pd.value FROM $wpdb->users u LEFT JOIN {$bp->profile-&#
How To Run A Left Join Query To Get Coulums In One Table?
Hello, I have data saved in wordpress postmeta table, each post_id has some meta_keys, the table looks like this: [code]------------------------------------- post_id | meta_key | meta_value | ------------------------------------------ 1 | project_id | 1 | ------------------------------------------ 1 | height | 50 | ------------------------------------------ 1 | width | 100 | ------------------------------------------ 2 | project_id | 2 | --------------
Doesn't anybody think MySQL is so hard to code? I mean think about it, you need loads of databases just for one little script and you have to type things in like <MySQL> ;Host-Username: (blahblah) ;Host-Password: (blahblah) ;Host-DatabaseName: (blahblah) </MySQL> Ok, that MySQL code was random, and it is alot harder than that. If you have expierenced it being hard, you are free to post right in here, mate.
So I'm trying to install 10g on my XP Pro development box, and the install goes fine (I do the basic install of enterprise edition, I'm by no means an oracle expert) and when it gets to the part where it wants to create a database, the database creation assistant fails saying first that it cannot retrieve credentials, and then that it can't connect to ORACLE (I'm assuming this is the instance name). Anyone have *any* idea what's going on here?
How To Upload A Database Into Internet
i have developed a database on my system and want to upload the database on to the internet and use it for my website how do i do this
I have made a website and it has a simple comments feature on it so viewers can comment on my page. I have added a filter to filter out swear words but what is a way to stop people from spamming and ban them from the site for a period of time if they do spam my site. I do not require a login to view my site and was hoping to do this without forcing people to login. This may be more of a php question than mysql but I will have to use both to solve my problem i'm sure. Anyway, any advice would
What Are The Alternatives To MySQL
Hi. i'm interested in alternatives to MySql combined with php. what database else can i use to create a webbased managment system with a lot of entries. maybe more than mysql can handle fast enough. it should be more powerful than mysql and should have nearly the same features. i hope there is a webbased administration program like phpmysqladmin thanks for your help ! greetings c.
MS Access DB To Webpage Connection ?
ok .. i have this little problem i am going through ... Leme explain this project of mine first . I have a MS Access DB of student fields like ID no, Name, Marks .. etc .. This one Access DB would be updated by just adding more rows and would be done on the server. It looks sumthing like this: [img]http://i1.tinypic.com/207xgkh.gif[/img] Now .. I have a HTML page that shows this : [img]http://i1.tinypic.com/207xfz5.gif[/img] I would enter the ID number of a student (no authentication .. anyo
Can anyone explain what is MS SQL?
I am learning database and i want to know the differernce between the primary and composite keys.. and something about the normalization.. thankx in advance!!!!
Need Advice On Creating Online Music Database
I need to create a database of around 1000 music albums that I can put on my site, with the ability to search the database according to several different criteria. Being a complete and total NOOB to the world of databases, can anyone point me in the direction of some software that will let me create a good-looking and functional database, but that isn't too complicated for me to use?! Sounds like a tall order I know, be grateful if anyone can help though. Thanks! Notic
MySQL Output Database Question
I am new to MySql and have just created a database after using a script. My problem is not the script, but what it says about putting it into the output file. I cant figure out the right terms to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE 'location' but it isnt working. I'm lost with this stuff, I really am. Can someone please help me out?
Tell Us Which Database You Use Mostly
Tell us which database you prefer, and which one you use mostly (they are not necessarily the same). I would say that Oracle is the king today : the most robust on the market, it handles really huge databases, the parallel query feature is really fantastic when you have a quite a lot of disks (let's say some thousands) and a lot of cpu's. Unfortunately, as most of powerful professional things, it's rather expensive. I would say that mysql is currently the most widely used, including
Oracle announces the availability of MySQL 5.5 - Better performances. - Higher availability - New options, like table partitionning and index partitionning. Download it here : [url="http://www.mysql.fr/downloads/mysql/5.5.html"]http://www.mysql.fr/downloads/mysql/5.5.html[/url] Read the WhitePaper here :http://www.mysql.fr/why-mysql/white-papers/mysql-wp-whatsnew-mysql-55.php.fr
Can Someone Help Me Modify This Login Script? [solved]
i had this login script,i lowerized its functions a little bit but cant do more it too complicated for a newb like me can some one help me delete the activation throu email codes in these files,and those extra fields on registration form and their DB's fields for me plz? all i want from this script is that i want to login wit 3 different user access
How To Go To Index.html From Login.php Page
hello huys im new here and to php and data base connections i have a question,i have this page as my login page >>> login.php [code]<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Login</title> <link href="loginmodule.css" rel="stylesheet" type="text/css" /> </head> <body> <p> </p> <form id="loginForm"
How To Make A Country Drop Down List In Wordpress?
I am using wordpress, my theme gives the option of adding user profile field. When I add Country field, I can chose drop down list as this field input method. But it's simply imposible for me to type in hundrads of countries to make the drop down. Is there an easy way I can get the country drop down list?
Newbie Question About Database
On free hosting, the max database space is normally around 50MB. I have no idea how this 50MB works. I plan my website to host a community and run multi services. Is 50 MB enough? If 50MB not enough, where I can get a reliable database free hosting service? By the way, I'm not a tech person. I know nothing about database stuffs, but I am a fast learner-- able to learn basical things. A bit complicated is ok, but not able to dive into tech issues too deep. So, what would you recommend?
My friends have a little forum running [url="http://rohit.bizhat.com/forums"]here[/url]. The problem is that quite often we get the following message when we try to open the page: [quote]Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 48 Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/vhosts/rohit.bizhat.com/forums/db/mysql
Accessing Ms Access Database From A Centralized Location?
Hi I am a manager at a trading/wholesaling company (and have no programming background). I customized the Northwind sample access database to make invoices and keep accounts for my company. We now opening another office at a distant location. So, the order entry will be done at two points(we plan to use the same Access database). I am not able to figure out how to access the same MS Access database from two different location(as LAN can't be used). Moreover, we can't afford to pay huge
MySQL - Trouble With Bulk Insert Statements
I'm trying to insert about 500 rows into mysql, but I keep getting errors. If I copy and paste too many (about 50) insert statements at a time I get errors sometimes. I sometimes even get errors but then the row is skipped so I don't know there was an error (I'm using linux and SSH). What's the best way to get my insert statements to put the data in MySQL? Is there anyway that I can have it tell me if there where any errors all the statements are executed? Thanks for your help
This method is very useful. I always use this when simple queries of linking two tables is not enough. This method is putting a query inside a query. Example: SELECT * FROM table1 LEFT JOIN (SELECT * FROM table2 WHERE field1='id') AS subtable or joining multiple queries SELECT * FROM (SELECT * FROM table1 WHERE userid='001') AS subtable1 LEFT JOIN (SELECT * FROM table2 WHERE field1='id') AS subtable2 You can join more than two queries depending on the output you wan
Recover Tables From A MySQL .frm File
I have a couple of .frm files with no corresponding data or index files. Is it possible to recover the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is innodb
Script Tables On Sql Server Compact
So I have an application that's using SQL Server Compact Edition 2005. I need to export the table schema to a file of SQL statements, containing only the schema...no data, no rows, just the tables, indexes, and constraints. Now, when using SQL 2000/2005 I just use the script table as... feature to do exactly this, but because SQL server Compact Edition doesn't have the support for it, I can't do this. The tables in SQL Server Compact *do* have the information_schema views though,
Sample My.cnf - MySQL Configuration File
Hi all, Recently there has been lots of questions about configuring MySQL. Usually the rpm comes with a few sample MySQL config files, but here I'm providing you with a fully working one for your reference. Feel free to modify it to suit your needs. One word: My MySQL is configured to use only large InnoDB Databases, because of the large volume of transactions it handles. You'll find a reflection of that in the my.cnf... Most home users would use ISAM DB instead. So make the suita
I know you can connect to data base and select a table, can you select a table get what you want from it then select another table with the same command, or do you have to close the first table (is their a command for closing a table)
Best Performance Databases From Not-so-far Future (published By Parts)
Part I Some time ago I was acquainted with one very fast bussiness-critical web-server application, and I became very interested, - how does this site work, outperforming fastest GUI applications? And what was told to me. Design has to met with very tight requirements for performance of system: simply to be the most powerful solution by performance, given that it should run on ordinar server equipment. The guys who get this proposal owned some parts of this technology, so they brought up the
Hi, I want to put hebrew text in a (varchar) Field but instead of to see the right hebrew characters phpmyadmin put couple of question marks! Even wehen i import my csv file within combination normale char and hebrew char AND i set Character set of the file: to UTF_8 or Hebrew, I still get de quistion marks in place of Hebrew characters. How can i setup right phpmyadmin to get my hebrew char right?
Using Php To Access Multiple Tables From Mysql
Hi guys im new to php and mysql and have a problem that the book im using and online manual doesn't seem to help me with or I might be overlooking it. Here's the deal I've created a few tables (acura,honda,lexus etc.....)under a datatbase called "cars" . under the tables are categories such as userid,make and model , and a description . I've created a search form with drop down selects and a search box to search the database. What I cant get accomplished
Hi Guys. I am a developer the does a lot of developing for the web in PHP, I need MySQL. I have Apache Web Server and phpMyAdmin installed on my laptop. I can get phpMyAdmin to work but I can't use it because I can't find a file that will let you set up an account. Cheers
How To Connect A Java Applet Or The Html To A Database
i was wondering how to connect to the database from some other source like java or html i just got to know that the connections are made through a jdbc or odbc connection but how to establish them is the question if anyone could answer it i would be happy
Mysql Database Entry By Excel Sheets
Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to mysql database. Thanks
I have just set up mysql and phpMyAdmin. I tried to log in to phpMyAdmin with the correct login of root with no password. PhpMyAdmin didn't care, it just said "Please fill in the password field". Then I tried a couple of sql commands with PHP to change the root password, but none of them worked. Can someone please give me a PHP script to query the database to change the root password?
IS it possible?? is there any program that does such a thing??create tables automatically when i tell him which script to do it on?? and how much would a guy ask from me to do it instead of me?? Thanks...Eggie
Connecting To A Remote Database
I wondered if anyone here can help. I have a database on a remote server (A). I want to access it through a php script on a different server C. I have allowed access on (A) in Cpanel - mysql dbases - Remote Access by putting the IP address of server C The host of server (A) has also whitelisted the IP of server C. Though I am having trouble connecting from server C which is with a different webhost. any ideas how to get round this? I have though of SSH forwarding, but I think this can only
How Can I Import Csv Files To My MySQL Database?
I am having hard times finding that import csv in the mysql phpmyadmin. I once worked on some csv files and someone imported it on the mysql server. I was not able to ask him. Does someone know how can I import csv files in mysql server?
Read/Write Issues After Copying An Access .mdb File
Alright, I'm currently creating an interface program for a MS Access database. I've only used Access once in the past but used other DB's a handful of times so I didn't have any trouble getting the general program created. My issue arose when I tried to make it so that the users needing to use the program can just copy the .exe and the .mdb files and use it. The program doesn't require users to share the database but to store their OWN programs information in their OWN datab
Hii Guyz, I am having this little problem creating a query in MySQL. Problem description: Table: mytable Table Structure: IssueId | ToolName | Status 01 | Tool1 | Open 02 | Tool1 | Closed 03 | Tool2 | Closed 04 | Tool3 | Open Now, I want to get the results in the following form: ToolName | Count(Open) | Count(Closed) For the above input, result will be: Tool1 | 1 | 1 Tool2 | 0 | 1 Tool3 | 1 | 0 There should be NO duplicate toolName in output. Thnaks, Manu.
I have to create a whole project using Microfost Access. I have a field which will eventaually contain details of a a list of people's DOBs. I have added an input mask, so that it it displays the place holder __/__/____ However, how can I validate this field. For example, not it is possible to type 30/10/1991 [dd/mm/yyyy]. How can this be changed so that it validates it correctly?
I am trying to get a category name form a table(categories) based form a id form another table(stories), I can kinda do it but it gives me the wrong one because it's in more than one category. here's the two tables with only the fields I need to use and sample data in them. categories[TABL][TROW][TCOL][b]catid[/b][/TCOL][TCOL][b]parentcatid[/b][/TCOL][TCOL][b]category[/b][/TCOL] [TCOL][b]other fields[/b][/TCOL][/TROW][TROW][TCOL]56[/TCOL][TCOL]2[/TCOL][TCOL]Right one 1[/TCOL][TCOL]othe
What Kind Of Databases Does This Server Provide?
What kind of databases does this server provide? i want to know about the databases that i can use in this server ... regards christian
A Very Small Db Class For Beginner
May be it helps for an MySQL entry [code]</P><P><?php class Db_Default{ // connection var $db_user = 'username'; var $db_pass = 'password'; var $db_db = 'database_name'; var $db_host = 'localhost'; var $connection; // table names (examples) // --one user has many needs-- var $tbl_user = 'users'; var $tbl_user_needs = 'user_needs';
Want Help In Connecting DB To Java
Actually i know how to create an independent database and how to update it manually. But i just want to know that how can i make that update thing automatically. Like suppose if i give somekind of username and password to members of my site and i wish to have them updated , like addition , deletion or changes in password, to be automatic how can i do that. i have a rough idea that it can be done with the help of Java and jdbc but i don't know exactly. I m good at programming languages C an
How To Understand A Database Schema
Yesterday while i'm seaching for a data model and database schema at the [url="http://www.databaseanswers.org/data_models/"]Library of Free Data Models[/url] for a new project of a friend of mine i found there this nice and simple tutorial on [url="http://www.databaseanswers.org/tutorial4_db_schema/index.htm"]How to Understand a Database Schema[/url]. As its name says, this tutorial will help you to better understand a Database Schema and covers the following basics topics that every Databa
When it comes to the best Database, a lot of stuff needs to be considered 1) Size 2) Ease of use 3) Embedded Nature 4) Licensing 5) Enterprise Orientedness 6) Features 1) Size: Oracle is synonymous with databases in companies where there are a huge number of records in the database. Nothing can come close to it. 2) Ease of Use: Well, this stands for the interface. There is quite some competition here. Oracle is good. MySQL has some third party GUI and cli interfaces that can ease out the job.
Is there an "easy" way to update a database's tables? Like for instance, I have my own custom-coded member login system. Whenever I add a new feature that needs a database, I manually have to download, update and upload the database. Is there an easy way I can do this? THANKS!!! [N]F
Can't Import Backup Sql File To Localhost
Hi, I downloaded a backup of my forum database and wanted to import it on my computer locally for testing purposes. This has always worked for me in the past, but I'm having some problems with it lately. I'm backing up my database via phpMyAdmin->Database->Export->Select All and downloaded as a .gz file. I'm using Windows XP Home with WAMP installed, so it has MySQL built in. It's version 5.0.27. I ran all the services and at the prompt typed in: [b]mysql -u root -p
Hi, maybe one of you already came across this, so I ask. I'll continue searching on. I've got two vocable trainers, one is Windows-native, the other one is on the web. While I can't control the output of the Windows-thing (so I can't export them to a *csv or something), I can write an import script. But since I'm not that great with Regular Expressions and don't know anything about *.mdb (that is MS SQL, isn't it?) files, I would need some finished thing to make out
Have you ever worked on Curl with php Is it easy to learn? Any one has a tutorial for Curl
MySQL Datetime --> VB.NET Datetime Conversion Prob
Hi, Can anyone provide me with a quick example of fetching a MySQL Datetime Field and converting it into native VB.NET DateTime format ?? Say for example my db contains a couple of fields: Field1, Field2, DateField... one of which is the default MySQL DateTime. Say I'm using the following code to connect... [code]ConnectionString = "....." QueryString = "SELECT * FROM SomeTable" Dim myConnection As New MySql.Data.MySqlClient.MySqlConnection(ConnectionString) Dim my
Stop AUTO_INCREMENT From Jumping
One of my MySQL tables has an ID column - it's a primary key with auto_increment. And it works. If I add six rows they number 1 to 6 nicely. But if I delete rows 4 to 6 then add a new row, it becomes row 7. And if I delete that it becomes row 8. How can I make it so the next auto_increment is the smallest possible? (i.e. 1,2,3,4,5,6 - I delete 4-6 and the next row inserted becomes 4)
[quote][size=5]M[/size]y whole php code begin with [color="#ff0000"]<?, not <?php[/color] so i upgrade from php 2.2.x to 2.3.0 apparently, now it will only work if my php code start with <?php if i start with <? it will just dump it as html. i got hundreds of php files, most are mixed with html code where php code are all over the place between html, I don't think it's a good idea to automatically do search and replace. to manually do sea
I want to make a login system using Mysql. I am amateur in these things so please explain in detail like spoon feeding. I have already made a database in [url="http://www.sitebooth.com"]http://www.sitebooth.com[/url] now what type of table I should make and and the website or PHP for it . If you think i hav chosen wrong site please give any better database hosting site. Please help me Best Regards Pritesh Gupta
I have just installed MySQL and ran the configuration wizard. The wizard failed to start the service, and I can't start it using services.msc either, this is what comes up in the Windows Event Viewer: [quote]Plugin 'FEDERATED' is disabled. Plugin 'InnoDB' init function returned error. Plugin 'InnoDB' registration as a STORAGE ENGINE failed. Unknown/unsupported table type: INNODB Aborting Forcing shutdown of 1 plugins C:\Program Files\MySQL\MySQL Server
Description: It's a wordpress blog in Hebrew that its database was erased by accident and then restored. While the DB was restored it lost its collation. Instead of the original Hebrew characters I now see ??????? I tried to change the collation in the config.php and in the DB, tables and fields through the phpmyadmin, but I still get the ?????
Database Access On Remote Server W/jsp
Hello: I am new to JAVA and server-side applications and have a dumb question. I have set up Tomcat on my machine and created a JSP program to query an Access database using a DSN-Less connection. If I publish the page to a webserver and include the .MDB file will it work? I'm not sure exactly what needs to be packaged with my Java application to make it work. Since I don't have a remote server that supports .jsp I cannot really test it. I'm assuming that JDBC driver would be b
Iam thinking of starting an online game, I have some knowledge in PHP and C++ skills. But I am still new to mysql. I have 2 things to ask, the first is a bit of topic but does this sight allow me to host a game?. 2, how do i make a data base. You know units hp, attack and other characteristics. + people making acounts (sign up by email and verify) and all other things. Can any one help me?
Dbms Features And Capabilities
[quote]=Alternatively, and especially in connection with the relational model of database management, the relation between attributes drawn from a specified set of domains can be seen as being primary. For instance, the database might indicate that a car that was originally "red" might fade to "pink" in time, provided it was of some particular "make" with an inferior paint job. Such higher [url="http://en.wikipedia.org/wiki/Arity"]arity[/url] relationships pro
Mysql --- Multiple Entries Single Field
Hi all first off I am new here so let me take a second and say hello to everyone for the first time. Iam also fairly new at working with php and mysql actually trying to create my first site using these however I am kind of stuck at how to do something so that it comes out right hopefully you can help me out here. i am trying to figure out how to do multiple entries for the same field an example is this an event calendar where the event is held yearly and I want to be able to go back each year
Mirror My MySQL Database To Another Mysql Server
Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql server?or create a small php script to do this? The reason is because, we all know that database is very improtant if we have dynamic website. I have my forum hosted and i want to automatically mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid that i forgot to backup my database..also i have one central backup database. Thanks for the help..Im looking
Hey guys, I'm new when it comes to data basing anything so maybe my post should actually go here. Here is my previous thread on my situation, and do you think that this will all be covered in my basic database? [url="http://www.astahost.com/Bit-Please33-t19865.html"]http://www.astahost.com/Bit-Please33-t19865.html[/url]
hi, i need help with connecting to a mysql database, i am developing my application in microsoft visual studio with vb.net and require help with the code for the connection string, as i am not using ado.net to connect to the database, i am using a vb class file to connect to the database. [codebox]Private Sub OpenDatabase(ByVal DatabaseName As String, ByVal TableName As String) 'declare a variable to store our SQL Dim SQL As String 'declare a new command builder Dim CB As OleDbCommandBu
Hello, I have ASP application with MS SQL Database. Now i want to migrate it to DB2 Database . Is there any wrapper which supports MS SQL to DB2 conversion in ASP ??
I'm wondering what the most efficient way of doing this is. I have a table with users in it, each user has a unique id. Now suppose I had a table with groups in it. Each user can join the group. I estimate that the maximum size of a group would be 100 users. How do I store the user IDs in the group table? Do I make a column called `members` and store them in a semicolon separated list? If so, how do I delete members? Then again, there might be other methods I've never even thou
What is the best free database if some one trying built a social networking website? And how to operate it with dreamweaver 8?
I don't know if this is the correct forum, but here is my question: I'm trying to test Joomla and some forums in my computer, I have already installed MySQL with the GUI tools, Apache, and PHP with the MySQL and MySQLi extensions, but when I'm trying to install Joomla I get this error: [color="#8B0000"] Required Settings Check:[/color] ------------------------------------- PHP version >= 4.1.0 Yes - zlib compression support Available - XML support Available - MySQL
[quote]A computer database relies upon software to organize the storage of data. This software is known as a database management system (DBMS). Database management systems are categorized according to the database model that they support. The model tends to determine the query languages that are available to access the database. A great deal of the internal engineering of a DBMS, however, is independent of the data model, and is concerned with managing factors such as performance, concurrency, i
How To Replicate Ms Sql 2000 To Sql 2005
[b]Hi all, I was having 2 SQL 2000 Servers and I have enabled snapshot replication. Its working fine without any issues. Now I have upgraded one MS SQL 2000 to MS SQL 2005. Is it possible to replicate the data in SQL 2000 to SQL 2005. If possible, how can I do that? Need your help to setup it. Thanks...[/b]
i have just got hosting here on astahost and i have to copy my databases from my old server... is there an easy way of doing this? in phpmyadmin? thanx in advance you know lol
Free Or Opensource Database/schema Browser?
I was wondering if there were any alternatives to TOAD or PL/SQL Developer that allows you to browse through a database(s), the different schema objects, and perhaps the stored procedure/function/packakge editors. One thing I have tried is to the use the Data Tool Plugins set for my Eclipse but that brings my machine's performance to crawl. One a further note, I am basically looking for Windows environment, with connections to remoate databases.
Sometimes in a table especially if i do alot of things in it i start seeing overhead then a size near it? what is overhead? and is it essential to optimize the table to fix it? I know its just a press of a button but i'd like to know what happens when i optimize a table. Also when you make a new table you can limit the size of VARCHAR to a number, that number would be the number characters allowed in that column per entry. I'd like to know how the limit works for texts, is it in KB? or
Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just played around with the demo. Has any one used it beore, if so please let me know if its worth buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility and functionality. Regards
i dont know if this might be useful to ppl here, but this is a very good knowledge for serious siteadmins. while i was digging for mysql backup techniques, i've found that mysql is able to do realtime replication. the idea is that there are master server and slave server. both are having the same version of mysql installed. the data flows; Master >copy> Slave ( in realtime!) you'll never have to manually copy the database file of wasting your time to manually use the mysqldu
I thought I would take a moment to point the users here to some of the database resources available for reference and learning. First I will start with actually designing the database. [url="http://r937.com/relational.html"]This site by R937[/url] covers the basics of database design. The author is professional database guru and a frequent helper at the at DB forums listed below. [url="http://www.databaseanswers.org/data_models/index.htm"]The Library of Free Data Models[/url] is an excellen
Any Website Provide Free Host Mysql Host?
any website provide free host mysql host? i need it because i am using 000webhost.com now but it only provide 2 mysql database... can i know where or how can i get more databases regards
Hello, i would like to know what server is the easiest to set as a web server?
Hi guys, ive got a registration system that looks something like the one below: [codebox]<html> <body><form action="insert.php" method="post"> Firstname: <input type="text" name="username" /> Lastname: <input type="text" name="password" /> <input type="submit" /> </form></body> </html> [/codebox] Then i have inset.php, which looks like the following: [codebox]<?php &#
Iam assuming the information in the databases i will create will be stored in the 500 MB space i get, but since 500MB isn't enough iam wondering if you guys can tell me how much bytes the following take: Varchar(x),Tinyint,Text,date,smallint,mediumint,bigint,float.... And the rest present when you add/edit a row in a table. Also what are the ranges of tinyint,smallint,mediumint and big int
I posted PHP on computer? , but for some reason it doesn't show :/. Anyways I am wondering if there is MYSQL on my computer, meaning can i make a data base on my computer? that way i make what i want and upload it when i get hosted =)
Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE (Store#, City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed database for a bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST. Consider tha
HI, I've hit the grain while trying to import file to mysql database - I need to enable file permissions of the database user but this seems not possible with most of the hosting providers. The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only allow privileges on table querries but you cannot grant host file privilege
I Have An Error With My Mysql Connection
ok so here's my web page... [url="http://lacrossems.t35.org/"]http://lacrossems.t35.org/[/url] it only lags cause its trying to connect to the my sql server...i followed this guide [url="http://forum.ragezone.com/showthread.php?t=387249"]http://forum.ragezone.com/showthread.php?t=387249[/url] and when i edit my config.php to my host and login info i always get the error cannot connect to the database here is my config.php if you can help me [code]<?php $host['naam'
I was looking to make a site where people need to create an account, and log in to view the main pages. Is it easy, or do-able, to use msoft access to make a database where people are able to sign up with a username and password via my website?
Mysql Backup With Another Address?
I just got my site hacked!! (don't worry because it is not on astahost) Actually it is a wordpress blog. So I backed up my MySQL Databases with cpanel. Now when I get my hosting approved here at astahost, can I restore those backups? Is the change of the site address going to interfere with this? Is there anyway I can edit those databases to work with my new address? Please help me out here!
Integrate Access Database Onto Intranet Site
Hey guys, im new here and am looking for answers Firstly, i have designed a database using M$ access, it consists of multiple forms which i plan to host on an intranet website, i need to be able to add records directly from the form on the intranet website aswell as being able to edit/review current entries on forms in the database. My question is, how would i go about integrating these forms onto the intranet website? i plan on keeping the database and the intranet site on the same dire
SUN bought the swedish company MYSQL for much money, around 2million each worker got in the company, they did it to come in to the database market, is it a good reson to buy it?
How To Connect MySQL With Flash?
I know Flash and mysql but could not figure out if I could ever connect these? I want to have a dynamic content in my flash object that could be retrieved from the database directly without myself needing to update it again and again. How can I achieve this ? Do I have to install any additional controls or connectors to do that ? If yes any one tell me
I need to convert a database that is in Access 97 to Access 2003 but every time i do it using the Convert tools of Access 2003 i got some errors and can't change or add any of the objects -tables, querys, etc- of the converted database. All the errors i got are related to the user priviligies and permissions of the database, is there exists a way or procedure that allows me to reset this permissions??? Best regards,
I have two tables in a database. userid and usercredits In userid I have all the fields that identify the user (name, address etc.) In my usercredits table I have the following fields: IDNUM ProgramName Camp# CompletionDate Amount DatePmtSent PmtMethod Comments creditID What I would like to understand about my table structure, is how do I associate my credits tothe correct user. If I have done this correctly, there is also a field in the first table that is called IDNUM where each user ha
i have free script but it is working fine on a lot of sites i tried to use it to my web site ....i edit its config.php right and but my database name and my user name and password every thing right and when i try to install it it gives me this error can`t connect to database please choose file from this mobile.sql can any body help plz coz i tried huderd of times and no thing happend
Permission Problem With Mysql Database Creation
I seem to have a problem with accessing my database with proper permissions. I have set the my database correctly giving my db username all priviliges yet i seem to be unable to even log on with this username with a denied access error. Any ideas on resolving this?
©100Topics.net. All right reserved.
