CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 SQL script files

Print topic Send  topic

Author Message
Blair
Posted: 03/26/2003, 2:34 PM

Here is a section from the help of CodeCharge>>>


If it so happens that you are using a different database such as Microsoft SQL server, MySQL or PostgreSQL, there are SQL script files that you can use to recreate the database tables for the Intranet and Internet database. These files are also located in the “Examples” folder of your CodeCharge Studio installation and have the extension .sql. Essentially, these text files contain SQL statements that create the necessary database tables and populate them with values.

I am new to CodeCharge Studio and I am needing to set up MySQL database.

Does anyone know how to do the above in more detail. I am running for development purposes only on Windows XP , Apache, MySQL with PHP 4.

Is there a any example of how to do this that you know of
Karen
Posted: 03/29/2003, 4:01 AM

Start mysql and in the terminal, type the following command:

mysql [databasename] -u[user] -p < [yourfile.sql]

replace the values in brackets with your values. you can find more details of this command in the mysql manual. Hope this helps.

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.