In this tutorial, you will learn how to turn your computer into your own private webserver by installing XAMPP. Besure to SUBSCRIBE because there will be a new tutorial every week. Follow me on Twitter @RiverCityGraphx Like us on on facebook: on.fb.me Suggest tutorials at www.rivercitygraphix.com For project files, help forums, and more check out the website at http For business related inquires contact us at rivercitygraphix@yahoo.com
Question: How do you create an automatic backup for database designed in MySQL?
i built a database using MySQL. Now my client wants to backup the database once every week and every month. How do i do it ? Where do i find the tool?
Answer:
Answer by thundercats
If this is under a *nix environment, run a cron job that does a mysqldump.

In order to create a Web site, use Microsoft Word to input information and save it as an HTML file. Create a simple Web site as a starting point with tips from a software developer in this free video on using the Internet. Expert: Dave Andrews Contact: www.daveandrews.org Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department. Filmmaker: Tim Brown
Question: How do I create a MYSQL database in Dreamweaver CS4?
I have recently bought a copy of Adobe CS4 Master Collection. I am trying to create an online store. From the tutorials I have been watching, it seems it would be easier to have all the products in a database, instead of entering each of them one-by-one. The problem with the tutorials is they only tell you how to connect to a database. It never mentions anything about how to create one. How would I go about creating a MYSQL database using Dreamweaver CS4?
Answer:
Answer by Railgun
You can’t create a MySQL DB using DW. You will either need to setup MySQL separately on your local computer or preferably get a web host provider that gives you an instance of MySQL.
You’ll then need to setup and create your DB using any number of various DB client tools into MySQL.
Once you have an instance of MySQL you have access to, you can give DW the connection string and connect to it using DW. DW may have simple client interface for a DB already setup, but you can’t install the DB from DW.
And yes, it is most definitely better to put all the products in a DB. You could put all the products in an XML file and surely DW can open an HTTP resource that is an XML file. At leas that will get you started.
Why not learn Flex instead, server side web sites are so 1990s – i.e. snoooooooore.
www.1stoptutorials.com – In this four part course we will learn how to download a forum Simple Machines Forum (SMF) create a database with MYSQL. We will then upload our forum to our webhosting via FTP and then get everything set up so you can add a forum to your website. This is not a hard process. What you will need is some form of hosting that has a MYSQL Database and allows PHP, a domain name and a free ftp client. Please let me know how you get on and if you need any help. Thanks Guys and Gals
Question: How do I dynamically create arrays based on a mysql query?
Using MySql and PHP, I want to have an array created for each row in a table. How do I go about doing this?
Answer:
Answer by Chris
I don’t know PHP, but perhaps put your “array” into a temp table and read it like a normal table?
Question: How to import SQLServer create table statement to Access?
Hello I have file “.sql” which I believe is a sql statement for sql server
Some sql command from file
/****** Object: Table [dbo].[tbl2Down] Script Date: 12/1/2544 17:52:38 ******/
CREATE TABLE [dbo].[tbl2Down] (
[num] [varchar] (2) NOT NULL ,
[value] [money] NULL ,
[seang] [money] NULL ,
[day] [varchar] (10) NOT NULL ,
[sell] [money] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[tbl2Up] Script Date: 12/1/2544 17:52:38 ******/
CREATE TABLE [dbo].[tbl2Up] (
[num] [varchar] (2) NOT NULL ,
[value] [money] NULL ,
[seang] [money] NULL ,
[day] [varchar] (10) NOT NULL ,
[sell] [money] NULL
) ON [PRIMARY]
GO
How I can import .sql to microsoft access
Thank you
Answer:
Answer by Charles R
Access uses VB data types for instance varchar would be type text. In Access it is usually easier to create a table in design view. If you want to mix SQL Server and Access look into Data Projects or ADP. This lets you use Access as a front end and SQL Server as a backend.

In this tutorial, you will learn how to create a database and table within phpMyAdmin. Be sure to SUBSCRIBE because there will be a new tutorial every week. Follow me on Twitter @RiverCityGraphx Like us on on facebook: on.fb.me Suggest tutorials at www.rivercitygraphix.com For project files, help forums, and more check out the website at http For business related inquires contact us at rivercitygraphix@yahoo.com
Source Files – www.developphp.com Series Playlist – www.youtube.com In part 5 we create the administrator directory and set a link to the CMS administrator back end from the bottom of the home page. The back end admin directory will have its own index page to be the central home of the control panel. Learn how to build custom content management systems using PHP and MySQL. Cool dynamic basic sites that anyone can edit.
Categories
Tags
2005 2008 Access Apache Best Build connect Create Creating data database display error Excel from Handson INSERT Install Internet into Introduction learn Microsoft MySQL O'Reilly Oracle page Part phpMyAdmin problem Querying server statement table Tables this Tips Training Tutorial Tutorials Using Video Visual website Windows

