Jiju Thomas Mathew asked:


MySQL Backup of mixed type tables have been a night mare for me always. When it comes to the Win32 port serving a client application, which was a recent client requirement we at Saturn had to grease our brains a little too much. Finally all the requirements were met.

The Requirements were that all triggers, proceedures and functions along with table defenitions, permissions and data should be backed up. The backup and restore should be with maximum efficiency. Triggers should not be triggered when restoration is happening.

Considering all the above points, it was finally decided, to go with a suggested solution as follows. The structure of tables would be taken using show create table, parsed and properly formatted to a particular markup with a create table, a load data in file, and a set of alter tables.

Considering tables with mixed types, ie some tables are InnoDB, and others MyISAM, all InnoDB tables will be converted to InnoDB after the data has been populated, if there are any indexes ( there should be), and even auto_increment primary keys, are built after the data is populated. The data is taken as a csv using select into outfile. The triggers are taken from the data folder as files, and copied to a temporary folder.

The point where we had to break our heads were the functions and procedures, which was due to the mysql connector/v5 which we were using did not support delimiter, and finally what we did was to dump the proc table from mysql database with the same method. All the resulting files are zipped together with some meta information.

When the Restore was developed, we faced another problem, that simply dropping the TRG files did not activate the triggers, but we needed to restart the mysql server.

Finally all is well and the client is satisfied. The backups, taken will only be a full backup. But for the incremental one, it would be better to enable the replication service, and use mysqlbinlog.exe.

We at Saturn is committed to inspiring and leading people into using FOSS solutions.

Ravi Kant asked:


PHP/Mysql in Web Development

PHP and MYSQL are two of the most popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful server side scripting language designed to enable developers to create feature rich Web applications quickly and MySQL is a fast, reliable and robust database that integrates well with PHP and is suited for dynamic Internet-based applications. They run on both linux and windows servers so your web host most likely supports it. If your site needs to be updated with fresh and constantly updated contents, then you must have a database driven site design.

Technoscore is a  web development company in India, which specializes in Database driven websites designed using LAMP (Linux, Apache, MYSQL and PHP) with content management systems (CMS), which help you update/administer your site without requiring any external intervention.

Even though Technoscore is a Indian web design/development company, they have been serving Global customers since 1999. Their services include php-mysql-web-devlopment and MySQL web development, ecommerce web sites, PHP-MySQL offshore development and

PHP programming services. They have an Offshore dedicated Team to work on any php/mysql project and have it delivered on time, per your specifications. In addition, they are also skilled in flash design, and have worked on several large projects involving flash for overseas clients.

Technoscore is a premier resource for PHP development. Their PHP solutions include the following.

Shopping Carts

Order Tracking

Credit Card Processing

Content management System

Form generators and form processors

Image galleries and stock photo applications using ecommerce

Web traffic analysis

Virtual communities

Blogs

Polls and Surveys

Feedback Forms

Ratings and Reviews

Mailing Systems

Integrated Search

Online Chats

RSS Feeds

Back-end Administration panel

So be sure to check Technoscore out.  They will leverage the cost saving advantages of the above open source technologies to deliver full featured, scalable web solutions while providing quality customer service at the same time.

Contact Technoscore today, and ensure great savings, while successfully outsourcing your web development project.

John Ugoshowa asked:


CPanel is an easy user-interface site that lets you control your host account environment. The main peculiarity of this operating system is that it so simple to use that your below average computer user can’t mess it up. It’s got great features embedded into its panel and some of the features are listed below.

Site Tools

There are such tools available for your use, which are Web Protect (.htaccess editor), Custom error pages, Redirects, Ability to edit MIME types, Ability to edit Apache handlers, Install/Uninstall FrontPage Extensions, Search engine tool submitting and File Manager.

Email

The email program provides you with the possibility to add, remove, and change passwords while managing email accounts. CPanel is also provided by Webmail for the accounts, Auto responders, Forwarders, Mailing Lists, Spam filtering and some more.

Backup

Backup allows you to create copies of account files and databases. The backup menu also allows you to download any automatic backups that were downloaded by your CPanel administrator.

Stats

Here are different tools to survey your site popularity and efficiency. Those are Webalizer web stats, Webalizer FTP stats, Analog stats, AWStats, View latest visitors, View bandwidth usage and View error log modules.

FTP

There is a module that controls FTP accounts (add, remove, change password for its access), Anonymous FTP controls; Ability to change FTP login message and Ability to kill FTP sessions.

Advanced Stuff

You have an ability to add or remove subdomains, Subdomain Redirects and its Stats.

Advanced Tools

You are provided with tools of SSH access tools, Manage GPG keys and Cron jobs.

There are also Pre-Installed CGI Scripts. Those are Interchange Cart, Agora Cart, Bulletin Board, Java Chat, HTML Chat, phpMyChat, CGI Wrapper (for non-suexec installs), Random HTML generator, Advanced Guestbook, Counter Generator, Java Clock Generator, Java Countdown Generator, Secure FormMail clone, CGIEmail, Entropy Search, Entropy Banner. Network Tools are DNS Lookup and Traceroute. Database Management tools includes Managing MySQL databases and phpMyAdmin access.

For beginners, CPanel has a lot of options that are easy to use. CPanel works with most of browsers, such as IE, Opera, Firefox and others.

Batman asked:


I have a mysql server up and running on my local machine, but I can’t seem to get a simple php script to execute on it. I thought I had php installed correctly. Is there some special folder I have to save the script in to make it work. I have it in my bin folder right now. Is there an easy way to know whether I have php installed correctly or not?

Sadain asked:


This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month, it is easier than ever to manage and run your own dedicated server. You can have guaranteed uptime from your datacenter, and outsourced support starting at $30/month. All you need to do is set up the server and get going. Whether it is for a web hosting company or a couple of personal websites, an inexpensive Linux server is powerful, reliable, and easy to setup.

Web Host Manager (WHM) is a common Linux based tool for managing websites on a server. Panel is a common control panel to manage an individual website. It allows you to add email accounts, view stats, make backups, install programs, etc. These 2 tools are the most inexpensive set used commonly to manage hosting accounts, and you will find them very prevalent in the budget shared hosting world. It usually adds about $20/month to the cost of a dedicated server but provides most of the features of the more expensive tools.

Whenever you order a dedicated server from a datacenter, you will receive a welcome email with details of the server including the server name, ip addresses, and root password. This information will allow you to setup and configure WHM so that you can host websites and use your own custom Domain Nameserver instead of a raw IP address.

The first thing you need to do is the setup of Web Hos tManager (WHM). This includes configuring the default Domain name servers, main IP address, and server contact email address.

1) Login to root WHM (http://:2086) 2) In the left margin, click Next to run the setup wizard 3) Agree to the end-user license agreement 4) Edit setup a. Server contact email address: info@yourdomain.com This email address is being protected from spam bots, you need JavaScript enabled to view it b. Default Cpanel theme: x c. Default home directory: /home d. Home directory prefix: home e. Main shared virtual host IP: xx.xxx.xxx.xx (should be main IP of server) f. Hostname: server.yourserver.com g. Primary name server: dns1.yourserver.com h. Secondary name servers: dns2.yourserver.com I. Leave everything else unchanged j. Click Save

Next, you need to setup the system quota. To do this follows these instructions: 5) Click Next Step in left margin - system sets up initial quota. No need to wait for initial quota to setup….Click Next Step again 6) DOES NOT enable names ever. Click Next Step again

Now we need to setup the Resolve. This is specific to your datacenter and the information will be provided in the Welcome details for your dedicated server. 7) Resolve setup: a. Click Continue b. Primary Resolve: xx.xx.xx.xx (this is datacenter specific) c. Secondary Resolve: xx.xx.xx.xx (this is datacenter specific) d. Tertiary Resolve: leave blank e. Click Continue f. Click Next Step Not necessary to enter a MySQL root password 9) Click Finish

Initial setup is done, and you should now be able to login to root WHM. Now you can create the accounts needed to setup the name servers that you want to use on this dedicated server. 1) Login to root WHM again 2) “Create a New Account” (this is to be the main account: yourserver.com). Do not give this account a dedicated IP…. It will use the main server’s shared IP address. 3) Under “IP Functions”, click “Show IP address usage”. If only the main server IP is listed, that means you have to add the additional IP address to the server. Click “Add a New IP address”, and enter: xx.xx.xx.xx-xx Leave subnet mask unchanged, and click “Do It” 4) Click Show/Edit Reserved IPs, and check an IP to reserve it, and enter a reason (i.e. dns2.yourserver.com) 5) Under “DNS Functions” click “Edit DNS Zone”, then select yourserver.com and click “Edit”. Use the main IP address for the first 2 lines and the next IP address assigned to the server for the third line. A. Under “Add new entries below this line”, enter: server 14400 IN AN xx.xx.xx.xx (leave far right box blank) dns1 14400 IN AN xx.xx.xx.xx (leave far right box blank) dns2 14400 IN AN xx.xx.xx.xx (leave far right box blank) b. Note: The above entries are DNS entries for the two name servers being created, and the sever name dana.hostyourself.com. Once you’ve enter the three entries, click “Save” 6) If you get an “Error reloading BIND” error, go to “Restart Services” and click “DNS Server (BIND)”, then click YES to restart Bind.

That’s it! Now the server is all setup and ready to host cPanel hosting account with the name servers dns1.yourserver.com and dns2.yourserver.com. Of course you still need to go to your registrar and register these 2 new name servers and wait for normal propagation of 24-48 hours until the new name servers will work.

If this is a server being setup for a dedicated customer, be sure to tell them: 1) IP addresses of name servers so he can register them with his registrar 2) Root login information 3) Login info of main account you created for him 4) Tell him NOT to delete the main account, since doing so will also delete the DNS zones you setup above 5) New DNS zones should be added to the old server to help with DNS propagation.

If you follow these simple instructions once you get your server from the datacenter, then you will be ready to load websites and hit the internet. With cheap outsourced support companies available and world class datacenters providing under $99 servers there is no reason not to tackle the world of dedicated servers and web hosting for you.

For More Info About Author Visit At: - Cheap Domain And Cheap Hosting ! Free Videos ! Pay Per Clicks ! Cheap Domain And Much More about Search Engines

alexis a asked:


What Free Web site Hosting is the Best? No Down Server, No Ads, No Pop ups and Easy to use Cpanel??

Let me know what is your suggerstion and opinion?