How To Replicate Ms Sql 2000 To Sql 2005
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...
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:Now .. I have a HTML page that shows this :I would enter the ID number of a student (no authentication .. anyone can access anybodys marks), and when i hit submit .. I would be taken to a page that gets the
Hey,I am new to this sight so i don't know a lot of things.Some of these questions maybe off topic since I the FAQ forum does not work for me O_o.I put this under data base thread cuz the main question is about data base.Before that, I was told that i gain credits by posting. How much?Is it a fixed number per post or is it related to number of characters,words or lines. Does the content affect the number of credits awarded?Do replies give credits?Now that thats over I have questions about Da
Is Hosting a World of warcraft server Illegal?I ask because I was playing and I spotted a ad for a server. I do not have anything to make it with but would like to know before I do anything.Thanks, Apez
Well i have the codes for my game i got them from a friend of mine. He bought them from MCcodes.com and now i am tring to install MySQL to it.. but no luck with all other web host. I don't yet have a account for Astahost but "localhost" will not work no matter what host it is.. the last host that worked was from freehostia but it doesn't support cron jobs. mysql4.freehostia.com was the hostname but the rest of the web host i tried did not tell me the host name they just said to
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 http://www.sitebooth.com 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 meBest RegardsPritesh Gupta
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.
Hi,Now its the era of Embedded databases, no more db servers, no more host,Because with embedded db you can get all those options, what you are used to get with DB Servers.Some of Embedded DB Are1) Cloudscape From IBM (NOW Derby from ASF)2) HSQLDB (OpenSource)and many moreFeel the power of EDBCheersArunkumar.H.G
Accessing Ms Access Database From A Centralized Location?
HiI 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 sum
How does mysql_free_result() work ?
when I use mysql_free_result() to free the memory. . .seem nothing happened.how if I don't use this function.one more question is. ..mysql_close(). . why should I close mysql connection??
What exactly is mySQL? Is it a programming languauge like HTML, etc? I know that tables are very important in mySQL, and that the tables store all the data. But can you actually go about writing the code for a mySQL database?Thanks
I've a mySQL database backup which I used with my blog at another host which went down. I would like to restore my blog to what it was the other time. I wonder if I upload the blog installation files, restored the database backup, then specify the blogging program to use the restored database, will everything then turn out fine?Need help urgently, thanks
How To Use MySQL, PHP And Recordsets ?
I am just beginning to use PHP and MySQL together. I was wondering, in PHP, how do you access information you have retrieved from a MySQL database? I've used ASP with an MS Access database before, and in that scenario the information returned through an SQL query can be stored in a recordset. Basically, I am wanting to know how to do this in PHP.
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:mysql -u root -p backup.sql
This may sound pretty stupid, but what is MySQL? I am new to PHP and MySQL, and I was wondering if some body could give me a thorough explanation. I am working on getting 50 posts so I can open a forum myself on one of the servers. It might help if I know what I am doing. Thanks.Neil
i used below to display my banner<?$db=mysql_connect("localhost","root","");mysql_select_db("ad",$db);$result=mysql_query("select * from ad");$row=mysql_num_rows($result);$imagenum=mysql_query("select * from ad where ID=1");while ($image=mysql_fetch_array($imagenum)) {printf("<a href='$image[1]'><img src='$image[0]' border=0 alt=wallpaper></a>&q
I have a database that will contain 43 tables (among others). For these particular tables, they will each contain the same type of information, each representing a particular week in the NASCAR season. I used the following script to create one table:DROP TABLE IF EXISTS gulfOwnerDriversWeek1;CREATE TABLE gulfOwnerDriversWeek1 (ownerIndex int primary key,driverIndex1 int,driverIndex2 int,driverIndex3 int,driverIndex4 int);This table represents a draft sheet for one particular week (Week 1) for a
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 it
I'm using the following to retrieve data from stat_table<?php/* Include Files *********************/session_start(); include("database.php");include("login.php");/*************************************/echo "<table border=1>";$query = "SELECT STAT1 FROM stat_table WHERE GAME_ID=1 ORDER BY STAT1 DESC";$result = mysql_query($query) or die(mysql_error()); //runs the query$p=1;while($row=mysql_fetch_row($result)){$
I am trying to run the following asp function:code:--------------------------------------------------------------------------------Private Function GetAbs(dThisDate, lPartID) sql_abs = "SELECT AbsCode FROM Absence WHERE AbsDate = '" & dThisDate & "' AND PartID = " & lPartID Set rs_abs = conn.Execute(sql_abs) GetAbs = rs_abs(0).Value Set rs_abs = NothingEnd Function--------------------------------------------------------------------------------It works fine
I'm currently designing an Intranet but one section needs to provide a search on around 5000 documents (word and pdf). Rather than list them all on a page with links to the documents (take a long time to setup and maintain)I was hoping to include a search facility. This search would look at filenames within directorys and display a list of the files found. A user could then select the document they require to look atAny ideas how I might achieve this?Many thanks.
Selection From Multiple Tables
I am in the middle of creating a little forums system, and all so far is going quite well. However I have come across a small problem;PHP:-------------------------------------------------------------------------------- $gather_forums_qry = "SELECT a.frm_id, a.frm_name, a.frm_description, count(distinct(b.fth_id)) ThreadCount, count(distinct(c.fpt_id)) PostCount, a.frm_enabled,
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)
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.
I want to enter times for running event performances (like 10:26.35 for a person's 2-mile time, for instance). I am using sql server 2000. This is an ongoing concern for me since I do a lot of work with running events. Can someone give me some direction as to how I can best deal with this?The datetime data types do a lot of converting to 'time-of-day' and that is not what I want. For instance, if I enter a 2-mile time of 10:26.35 (a pretty typical 2-mile time) my db converts it to 10
I currently have a 100mb mysql database with my host, but I've got to thinking - is this really enough?I have phpbb running, and most of my site is in the database - username, password, other personal info, and then I have a table with 100 columns to which users add stats for certain computer games and more.The whole database is at 121kb at the moment, and this is without any members (but with the large table described above).The thing is, if I want to upgrade to the highest package, all tha
How To Dump .SQL File to MS-Access
Is there any way to convert a mySQL dump (.sql file) to an access file? Problem is, I downloaded and installed the mySQL server and ran it. But I couldn't restore the dump - it kept complaining about charsets and even the guy who created the dump didn't know what was up.So I'm looking for another way to access the contents of the database. Help anyone?
Examining Databases At A Whole Glance
Most of us using databases or doing data minings are not aware of SQL-92 specification seemingly these days.SQL-92 specifiaction is the SQL database query language standard.Oracle,mysql postgresql,mssql and DB2 - most widely recognized SQL database programs - are all closely related to SQL-92 specification for the use of query nevertheless how they implemented SQL-92 specification features inside in the program.Implementation of SQL-92 specification features are applied in the order of Oracle, p
I try to access to a remote mysql owned by my friend , I have the IP and username and password.but I always got this information:Fatal error: Maximum execution time of 30 seconds exceeded in XXXXXXXXXXXXXXXX
If your server provide Windows or you can't use Mysql, you can use a database which made by Movable type. Although, first I should say that this method have not security & efficiency of SQL and Mysql .So, you can create a folder (name it DB) on Server and set security of folder to Full control for every one .Next step, open "MT.CFG" and delete settings of Mysql, just leave first line ( bِData Source./d).Note that, all of above should be done before you install MT and run
in mysql install directory:\mysql\bin>mysqldump -u root -p root your_DB_name > back.sql
login to mysql, type command below:mysql db_name < back.sql
How To Transition The Database
i want to transition the records in SQL7 to ACCESS in the condition of VF 6.0how i can?
The difference between MySQL and other DBMS
Maybe Mysql is the most popular DBMS used in Web programming, but what about the others such as Oracle, DB2?How to choose the better one in website planning?
Hello, i'm a newbie in using phpBB and I still lack knowledge in mySQL database. How do I transfer the datas(users,configs, all of them) contained in my current forum to another one in phpBB? I hope someone can help, a short but detailed tutorial would be good. Example is, if I want to move to a new host and I want to transfer all the accounts on my old forum to the new one. Thanks in advance, hope anyone here knows how to.
I want to know that is php supports MS Access databases. And could anyone told me the complete php installation.I have little bit problem during installation.
I keep hearing about this, & besides the price (which is expensive), I don't know anything about it or why I would need it, or what it stands for.
I am looking for some tutorial on line about how to use MYSQL and PHP, any ideas?
Steps in using the database at astahost.com
I'm building my website now and I'm anxious to know how to use the mysql.I have the development experience with Oracle and C++. But is new to mysql and html or asp.Would the experts here state the steps how to use the mysql here? Thanks in advance.
i am using a software to access to mysql remotelybut it display error!(Access denied for myusername@my ip address)please help me
Hey, I am trying to find out how to change the image in my forum. It's the image in the top left corner (see it yourself @ http://www.bmw-central.tk, register if you wish). If you know how to change it-- please let me know!
The front-end administration tool for SQLite
Hi,I'v wrote a tool for SQLite, I think this will help somebody.ezSqliteAdmin is a tool written in PHP & XUL intended to handle the administration of SQLite over the Web. It requires PHP >= PHP5.0.0 & Mozilla platform to run.Demo: http://ezdevelop.dotgeek.org
wut is a database and wut is it used for?
I will try to put a game server called EAthena that runs Ragnarok.Does that is possible to do??
Does this control panel allows backup of the database it has. Because i will need it.
Is there someone that could say me a good page where they teach how to use MySQL. I need to learn some.
How many databases in mysql can someone do in total??
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?
What is a MsSQL?
One suggestion about database backup
Suppose there are lots tables in your database instance, and there maybe lots data within them. Backup task may cost u many time.What I suggest here is to add one more table in the instance, which contains the current delta of every other tables. Structure of TblLogs:1) record id, to be the index of this table, maybe automatic increased.2) tableName, contains the name of every table3) delta can be a int type. increase every time when the certain table is modified (ignore of select operation).W
HelloI want to learn about MySql Database.Do any one know about free rescorces for learning it.Also a tutor for DreamWeaver MXI will be very thanful.Sohail Ahmedsohail4@msn.com
what is Datawarehouse.What is its use?why do we need it?And also a little intro of DataMining [An artificial Inetelligence approach to Database Development] what else>?
Problems With Php Saving Data Into Mysql
i have a server that says it allows php and mysql and in the control panel i can access mysqladmin and phpmyadmin but i cant get the php to save data into the mysql, i am trying to make a text-based MMOG so i need to save my users/passwords into a database(i thought) and it won't do it, can anyone help me
It's possibile to opne a connection to a PostegreSQl db using a proxy?Yf yes how?Thx to all in advance
How can I reconstruct my database?
How can I reconstruct my database?Help me it's importent!!!thanks to all.
how i can navigate all pages trouth index by using php and my sqlany body how can help me,please replay
Hello Guys ..After I get hosted in this site i wanna make a business site with xoops.. Can anyone tell me how to install and mantain it ?? ..
Please Help! SQL Problem - Thanks For Reading
I seem to be getting this problem on my website more and more often. I am the biggest computer newbie ever, so sorry if this is a bit of a stupid question , but is there any way to configure it so it avoids this mesasge?
Hi all how are you? I am just having a bit of an issue with my form script and mysql, inserting records from this form of mine into my table in my database.it looks like all my others and they work, so what could be so wrong with this. Herelet me show you the codeCODE<?php$host="xxxxxxxxx";$username="xxxxxxx";$password="xxxxxx";$db="xxxxx";$link=mysql_connect($host,$username,$password);if (!$link)die(&quo
Hi Guys,I want to learn to use MySQL in my site. I'm told that it is already installed. But I don't know how to use it.I've installed PHP Triad in my machine and with MySQL.Please hyperlink to a website containg articles on these.Bye,Bigyan
This message was in PHPMyAdmin!"The additional Features for working with linked Tables have been deactivated.PMA Database ... not OKGeneral relation features Disabled"Can anyone give me a hint to what this means?Everything seems to be working just fine.All my tables are errorfree and I haven't got a clue!But I'm not comfortable with having an error
this website offers Database hosting for free. Jus signup and u get u r own database .. it supports mysql, postgresql, sapdb, sybase, db2CODEhttp://freesql.orgfrom the webpageQUOTE This service is, and will remain, totally free. I have receive hundreds of Thank you emails from all over the world telling me that having this service available has allowed them to practice and learn without the burden of having to run their own server.
Looking For Decent DB Benchmarks
can anybody help me here.i'm designing a website + some applications for a company, all using the same database. now i'm looking for the best database, if possible a free one, no licenses and stuff. but other ones can be taken into account as well.so if you have tried it out yourself or know a site that has some reliable results, help me out.
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.
I want to install a paid to read script ,are you accept like these scripts? if yes ,could you tell me how to install it .( the script contain CGI and PHP scripts.thank you.
i got this error when installing phpBB manually when it asks for the prefix, i dunno what to fill in.
What is MySQL ? Can Anyone Explain
Hey. I have a few questions about mySQL. I'm just starting out on using it and am curious to know: 1) What exactly is it? 2) Where is it stored? 3) Does my computer have to be on all the time for other people to use my site? 4) Where can I get one? 5) How can I access it? 6) What does mySQL stand for? 7) Is there anything else I should know about using it?Any help with this would be appriciated. Thanks!
Is there a site with some BASIC info on this? I know this sounds stupid, but what do I need to start off with it? I have no experience with it. Thanks
....To use this tutorial, you need not know anything about PHP, and need only have had minimum experience with databases.phpBB is a stable, open-source, bulletin board script available as a free download from phpbb.com [1]. It allows you to set up an unlimited number of forums and categories. Users, moderators and user groups with varying permissions can be created. In short, it provides everything you'd expect of a bulletin board service. For a complete list of all supported features, see p
Difference MySQL And PostGRE-SQL
Can somebody explain me the differences between mysql databases and postsql databases. I have no idea what they make different.One thing I heard is that postsql should be better than mysql databases...but I have no What would you recommend me to use for a forum or so?
What can I use for a frontend to populate a SQL db. I have a lot of the data and records on Access db and I'm looking for an easy way to load that data into the SQL db.The second issue are updating the SQL db with new records added to the Access db. New records added to a table in Access are marked for web publishing and should be moved to the SQL db in real time or close to real time and the record should be added to the correct index on the website so visitors can see / search for the upda
The HP Learning center offers very good free lessons on creating databases with step by step instructions. You can access the learing center at HP Learing Center
I'm making a few assumptions so correct me when I'm wrong. Assumption 1:My website is hosted by a hosting company.Assumption 2:My M$SQL or mySQL database resides on a server on my network.If the 2 assumptions are correct. What are security issues I have to look at. Do I need to put the sql server in a DMZ with an inside and outside Firewall? Can the sql server sit on my network behind the firewall and nothing betwen that and the users.What would be the correct and safe way for data
MySQL Problem - Too Many Connections
when opening a forum, i get this message:Warning: mysql_connect(): Too many connections in /home/gotcha41/public_html/forums/db/mysql4.php on line 48Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/gotcha41/public_html/forums/db/mysql4.php on line 330Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/gotcha41/public_html/forums/db/mysql4.php on line 331phpBB : Critical Error Could not connect to the databasewhat could be the
Logic To Break Down An Access Tabbe To SQL
I have 3 differen tables in this database that are basically repeating the same data. How can I split it up and still use it.This is the horse project the 3 tables are called Horse, Dam, Sire. the Horse table should be enough for all the data. (at least that is what I'm thinking) the Dam & Sire are used to track lineage and are setup Like this:CODESireID; Horse; Sire; Dam; SireSire; SireDam; DamSire: DamDam; SireSireSire; SireSireDam; SireDamSire; SireDamDam; DamSireSire;DamSireDam;
what kind of things can i do with cgi and how do i do it. I need help.
what is mysql.how do i use it?what is it for?what can i use it for?do you have to learn anything like a new html to use it?do i need anything to use it?
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 mysqldump com
Could someone help me out with this? I understand a little about MySQL clusters but have never really set one up before.I am attempting to set up my first cluster but it will not start correctly. I am also looking into this:http://www.karkomaonline.com/article.php?s...004012416185184 Has anyone ever set up a cluster before?
Can someone tell me what is XQuery and XPath in simple terms?
Hi i am testing my site on my personal home server, it is based on my laptop running ms IIS 5 and PHP and ActivePerl, i want to know is their any free plugins available to run an sql server and database within the server to test some functions of the webspace, i understand that an ISAPI plugin will work.does anyone have any information that can help me or can you provide a link to a free programthanks in advance
Need Something Like EasyPHP.Org
Does anyone know where I can download something similar to what easyphp is offering such where apache, php and mysql can be installed as a single package?
Hi all,AM on a new project and they are opting for firebird as backend database. But i know MySql but i don't know much about firebird database. Can any one tell me about Firebird database. What are the differences between Firebird and MySql database. How the Sql statements are different from each other. What type of JDBC Driver available for Firebird. Can i switch my present application which running on MySql to Firebird, if yes what all instrutions do i need to fallow.Please help to get ou
hi @ all!i have a website with many partypics.. and now i want to have a counter! if anybody clicks on a pic, the counter which is placed under everypic should notice this! so for every pic i want a counter, which shows how often it was clicked and shown! with which scrpting language should i make it?which is the best for this quest?thx for help!greetz darul0r
Hi all, I had posted this same message in the General Programmng Section earlier but though it would be more related here.... so here it goes again. For anyone dabbling in mysql and .net, or learning mysql - either to develop software or asp.net web apps - this site is extremely useful and handy as a reference: http://www.connectionstrings.com - the site contains one of the most comprehensive and well covered lists of the database conneciton strings used by vb/c#/asp.net to connect to
What Is A Good Gui For MySQL ?
May I know what is a good GUI for manipulating mysql? Perhaps in the league of mysqlcc will be a good one Thanks for the help.And btw, who uses GUI for their Mysql here? I know that some people like to use console to type
i dunno why this query doesn't function..CODE$sql="SELECT count(*) FROM participantes,sancionados WHERE participantes.No_Ficha = '$no_ficha' or sancionados.No_Ficha='$no_ficha'";$query=($sql);any suggestion???
Hii Guyz,I am having this little problem creating a query in MySQL.Problem description:Table: mytableTable Structure:IssueId | ToolName | Status01 | Tool1 | Open02 | Tool1 | Closed03 | Tool2 | Closed04 | Tool3 | OpenNow, I want to get the results in the following form:ToolName | Count(Open) | Count(Closed)For the above input, result will be:Tool1 | 1 | 1Tool2 | 0 | 1Tool3 | 1 | 0There should be NO duplicate toolName in output.Thnaks,Manu.
I try to edit the welcome paragraph on my MB http://jwcgator.astahost.com and this is the error that I getWarning: fopen(welcome.inc): failed to open stream: Permission denied in /home/jwcgator/public_html/cpanel.php on line 90Warning: fputs(): supplied argument is not a valid stream resource in /home/jwcgator/public_html/cpanel.php on line 91Warning: fclose(): supplied argument is not a valid stream resource in /home/jwcgator/public_html/cpanel.php on line 92help?
howdy ya'll i am in need of a big favor. i have heard of all this stuff u get with web hosts like SQL and other weird databases. I HAVE NO IDEA WHAT THEY ARE! i know html and that is about it. i would really like to learn about the other things that people talk so much about. remeber i know ABSOLUTLY NOTHING about any of these things so u got to be SPECIFIC!!P.S. i know tons about other computer stuff i just never botherd 2 look into this stuff. so u can use big words
Erm does anyone know how i can increase or decrease the number of posts a person has in phpBB forums? I'm having trouble with that, can't find the link or something. I would gladly appreciate any help! Thanks
When I try to give one of my user a permission to access a secret forum, I get following error:CODECouldn't update private forum permissionsDEBUG MODESQL Error : 1064 You have an error in your SQL syntax near ' 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)' at line 2INSERT INTO phpbb_auth_access (forum_id, group_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_vote, auth_pollcreate, auth_mod) VALUES (13, , 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)
How Can I Make A Php Form To Save Info In Mysql
hi, in Mysql not only you can keep text or numbers but also you can keep files even of 50MB size.. for this to work you should set the Max_allowed_packet.. and you are done,,here is the procedure i have got for getting it done..==========================A.2.9. Packet too largeA communication packet is a single SQL statement sent to the MySQL server or a single row that is sent to the client. In MySQL 3.23, the largest possible packet is 16MB, due to limits in the client/server protocol. In MySQ
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 suitable
How Can I Backup MySQL Database On Cpanel?
I dont know how to backup the database to my computer ,in cPanel i click "export" (is that right), but i can't back the file to my computer >.<
Need Help In Database Auto_increment
i am creating a game and i set when someone registers than he gets id...in "extra" i have set it to be "auto_increment" but whenever new player signs up he gets number bigger than 210...(my first id was 211,next was 212,third was 213,fourth got 214) how to set it to go from 1 to infinite? thnx
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 ?????
My phpBB Doesn't Seem To Be Working?
I have created a phpBB forum a few weeks back and noq it seems to have gone beserk with some error with the mysql coding. Yesterday i tried to view it and it didn't work, showing up some weird mysql code (I'm a total noobie at mysql). Now i try to view it and it just doesn't load. Any ideas?My forum page is http://techslife.astahost.com/forumThanks
T-Mobile Sidekick/Danger Hiptop Friendly phpBB Theme
In order to make more sites sidekick accessable/sidekick friendly, a theme has been designed for phpBB. All it takes is a simple download from www.hiptools.net (not .com) and it needs to be uploaded to the board theme folder. The sk friendly theme is almost completely text based, so there aren't as many pics to load and it makes loading faster on the sk's. I'm planning on uploading it within the next few days. PeaceAaron
©100Topics.net. All right reserved.
