<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>MySQL Database</title>
<meta name="GENERATOR" content="WinCHM">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link REL="StyleSheet">
</head>
<body leftMargin=0 topMargin=0 marginheight="0" marginwidth="0"><script language="JavaScript" type="text/JavaScript">
function syn(){
if(parent.nav.tree){
if(parent.nav.tree.loaded){
parent.nav.tree.selectNode(9);
}else{
setTimeout("syn()",500);
}
}else{
setTimeout("syn()",500);
}}
if(parent!=self){
setTimeout("syn()",100);
}else{
parent.location.href = "../index.htm#page=MySQL_Database.htm";
}
window.onload = function(){parent.contentLoaded = true;};
</script>
<TABLE style="WIDTH: 100%; HEIGHT: 49px" cellSpacing=0 cellPadding=0
width="100%" background=template/topbar.gif border=0>
<TBODY>
<TR>
<TD width=5></TD>
<TD><IMG hspace=2 alt="" align=absMiddle src="template/main.gif"> <FONT face=Verdana color=#ffffff
size=4><STRONG>EzInvoice Users Manual</STRONG></FONT></TD>
<TD align=right width=60></TD>
<TD width=12> </TD></TR></TBODY></TABLE>
<DIV
style="PADDING-BOTTOM: 10px; PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 10px"><FONT
face=Verdana color=#5778bc size=4>MySQL Database</FONT>
<P><FONT face=Verdana color=#202020 size=2>
<FONT face=Verdana size=2>
<P><FONT color=#000000 size=2 face=Verdana>The below instructions assume that
you are using <STRONG>phpMyAdmin to manage your MySQL</STRONG> for the creation
of new databases!</FONT></P>
<P><FONT color=#000000 size=2 face=Verdana>The first step in the process is to
log into your server ( hosting ) account by way of a control panel or what ever
interface you use to access and control your account.</FONT></P>
<P><FONT color=#000000 size=2 face=Verdana>Login to your MySQL administration
interface. This will be the place in your account that you can add / delete
MySQL databases.</FONT></P>
<P><FONT color=#000000 size=2 face=Verdana><STRONG>We now need to create an
empty database named: ezinvoice<BR></STRONG>Once this is done, it should look
something like this:</FONT></P>
<P><IMG border=0 alt="MySQL Image 1" src="mysql1.png"></P>
<P><FONT color=#000000 size=2 face=Verdana>Once here, we simply click on the
Browse button and select the ezinvoice.sql from our MySQL folder. Then click on
the Go button.</FONT></P>
<P><FONT color=#000000 size=2 face=Verdana>This will now create the complete
database structure we need to use EzInvoice.</FONT></P>
<P><IMG border=0 alt="MySQL Image 2" src="mysql2.png"></P>
<P><FONT color=#808080 size=2 face=Verdana><EM>* NOTE: You can use this file at
any time to take your MySQL database back to the beginning. This would be used
for things like:</EM></FONT></P>
<UL>
<LI><FONT color=#000000 size=2 face=Verdana>You want to start over.</FONT>
<LI><FONT color=#000000 size=2 face=Verdana>A major disaster occurred.</FONT>
<LI><FONT color=#000000 size=2 face=Verdana>Other major events took
place.</FONT></LI></UL>
<P><FONT color=#000000 size=2 face=Verdana><STRONG>This file not only creates,
but also deletes ALL CURRENT CONTENT of the database!</STRONG></FONT></P>
<P><FONT color=#800000 size=2 face=Verdana><STRONG>**Use this file again with
caution! **</STRONG></FONT></P>
<P><FONT color=#000000 size=2 face=Verdana><STRONG>EzInvoice has a built in
MySQL Backup process</STRONG>, we would use this for disaster recovery instead
of the ezinvoice.sql file. This process allows complete re-creation of our
total invoice database. Remember to <U>chmod 0777</U> or <U>chmod
0755</U> the <STRONG>backups/ folder.</STRONG></FONT></P>
<P><FONT color=#000000 size=2 face=Verdana><STRONG>We now have our MySQL
database created and active</STRONG>. We can now
close the phpMyAdmin control panel and begin the
process of getting EzInvoice running and active.</FONT></P>
</FONT>
</FONT><BR>
<HR
style="TEXT-ALIGN: center; WIDTH: 100%; HEIGHT: 1px; BORDER-TOP: #5778bc 1px solid">
<FONT face=Verdana color=#808080 size=1> Copyright © 1997-2010 Mystic
Dreams Enterprises</FONT> </DIV>
</body>
</html>