Download Ibilling Accounting And Billing Software Nulled

Download Ibilling Accounting And Billing Software Nulled



An effective way to manage your business!

Contact management: Get a complete overview of your customers, including business history, notes, total income, invoices, sending direct mail etc. Get a 360-degree view of your customers.

Hassle Billing: Make your invoices and stay on top of your business. Everything kept simple. Designed to help you create the perfect bill, track payments and get paid faster online.

Localization done right: iBilling can be localized to target specific languages ​​and territories – Create your own currency, time zone, date format, etc.

Easy Accounting: Add your income, Post Cost & You’re finished. Fast, easy accounting for your business.

Advanced Reporting: See your business more clearly with Interactive Visualization and Advanced Reporting. So you can unlock insights that help drive the growth of your business.

Automation with extended logging :. Automation of planning, cron jobs, etc. generate money snapshot, Recurring invoices etc. Available control to activate deactivate

receive payment from customers: It is easy – to set up a payment plan with iBilling. Supports Paypal, Stripe,, manual payment or you can add more …

Advanced Email Configuration: Email directly using PHP built in e-mail function or Configure to send mail using SMTP

Real-time snapshot: Dashboard provides a real-time snapshot of the organization’s key metrics. You can easily visualize comparisons, patterns and trends in sales.

Turn Subscription Billing: It is easy to create and manage Recurring Billing Invoice. With iBilling’ll be ready to make Recurring Invoice, accept payments and focus on developing sales in a short time.

Password: 123456



For Code skype: dubeychandan996

datatable tabletools mutiple tab not working

$( “#tabs” ).tabs();

$(“#tabs”).tabs( {
“show”: function(event, ui) {
var jqTable = $(‘table.display’, ui.panel);
var jqTable = $(‘table.dataTables’, ui.panel);

if ( jqTable.length > 0 ) {
var oTableTools = TableTools.fnGetInstance( jqTable[0] );
if ( oTableTools != null && oTableTools.fnResizeRequired() )
/* A resize of TableTools’ buttons and DataTables’ columns is only required on the
* first visible draw of the table

datatable tabletools mutiple tab not working

write this function in jquery so tabletols is working in mutiple tab. or contact me with the code i will help you in 5 hour.
} );

Which Programming Language Should You Learn To Make Money?

I often hear people ask what programming language they should learn first. But the question should be: why do you want to program in the first place? If you are interested in it because it seems fun, then any language will do.

But I have a feeling some of you have bills to pay, and you’re thinking it wouldn’t be so bad if programming could foot some of that.

Now the question is more specific: which programming language should you learn to make money? Now the question is ponderable, but be warned, the answer won’t be the same for everybody.

The good news is that all popular languages are pretty fair in terms of compensation. The median pay today with 3-5 years of experience is around $60-80k/year, but that number can vary wildly, and can be much higher, particularly for folks on the east or west coast, or in consulting. YMMV.

The popular languages today are: Ruby, Python, PHP, Objective-C, HTML, CSS, JavaScript, Java, .Net, C/C++. Google all of those.

Each language has its popular uses:

Language Popular Use
Python/Ruby/PHP Server-side for websites and mobile apps.
Objective-C IPhone
HTML Client-side for websites. Markup language for building web sites, the ‘building block’ of websites.
CSS Client-side for websites. Presentation language for HTML.
JavaScript Client-side for websites, used to manipulate HTML/CSS. jQuery is what you need to know here.
Java/.Net Android programming. Server-side for websites, more popular with big businesses.
C/C++ High performance (stock trading) or graphics (video games).

Which programming language should you learn to make money? The bad news is probably not just one. The good news is you don’t need to learn everything about every language, just enough to accomplish your goals.

So which one of these should you pick up first? As you can see, it really depends on how you want to make money.

If you don’t care how you’ll make money, then my opinion would be this, in order: Python, Objective-C, JavaScript, HTML, CSS. You’ll also need to get some kind of database (MySQL, MongoDB), and learn how to program with it, although that’s not a big problem.

If you want to program video games or high-frequency trading apps, then C++ is probably the way for you. If you want to make websites, Python, Ruby or PHP are great, along with HTML/CSS/JS. If you want to program IPhone then Objective-C is the way.

JavaScript, HTML and CSS are used together and is used for making stuff look good in your web browser. They will always be used in conjunction with a server-side language such as Python, Ruby or PHP.

In the job market, you would not likely not be using all the languages I suggested, rather jobs are generally broken out by skills:

Job Role Skill Set
Back-end/Server-side Programmer Usually uses one of the following: Python, Ruby, PHP, Java or .Net. Has database knowledge. Possibly has some sysadmin knowledge.
Front-end/Client-side Programmer HTML, CSS, JavaScript. Possibly has design skill.
Mobile Programmer Objective-C or Java (for Android). HTML/CSS for mobile websites. Potentially has server-side knowledge.
3d Programmer/Game Programmer C/C++, OpenGL, Animation. Possibly has good artistic skill.
High-Performance Programmer C/C++, Java. May have background in mathematics or quantitative analysis.

Typically, there are folks who deal with the back-end and folks who deal with the front-end. These days there is a new crop of people who do mobile. Sometimes you can find people who do all of the above, but generally when you look for a job you will fill just one of those roles.

When learning these languages, start small. Don’t start by wanting to build the next Facebook, it’s not going to happen. Start with small projects and find tutorials. Google ‘hello world python’ or ‘hello world javascript’ to find simple tutorials to get started. Once you can program projects for yourself and friends, then you will be ready to put a portfolio together to try to get a job, or start with some freelance work to build up that portfolio. You can definitely do it.



I always recommend this to all my friend. You should never stop learning. And it is really important for a freelancer to learn not only new things but also to improve his skills. More skills can get you more work which means more money. Learning new skills will open up the doors of more and more opportunities.


I know it may sound funny. But many people do this to build up a good portfolio. Making websites for free kills your creativity and makes you complete the project as soon as possible. When making a website for free you will end up with something that you never expected. There are many reasons why this could happen. When making a website for free you will never do things too much carefully as compared to a paid project. And if you complete the free website you will end up with low quality work that you won’t even think of adding to your portfolio. So, i recommend not to build websites for free. I am not saying that you should never do it for non profits :).


Having a good portfolio website will increase the chances of you getting more and more new projects. Because you have something to show. I always recommend people to make portfolio websites that looks awesome and includes the use of almost every skill they have. So that you are able to show off.


I recommend that you start a Blog if you don’t have one previously. Owning a blog can earn you some money. But the main reason why i am asking you to start a blog if you don’t have one is that it can get you more and more clients. Also it helps you to practice your skills, experiment with your skills or try something new. By owning a blog you get one more way to show off your skills.


This is important that you make awesome websites that you can show off in your portfolio. And making awesome websites will act like a magnet and will also attract a lot of clients. I know it is really difficult to make awesome and unique websites and takes a lot of time. But the more unique and awesome looking websites you have the more clients you will attract. It will also improve your portfolio website showcase. Following this will attract a lots and lots of high paying clients. To make unique and awesome websites always follow the new trends like flat design. You can also include some advanced techniques like parallax scrolling.
Making an awesome and unique website not only means designing it. It also includes development. As a web developer you can make websites more awesome by adding tight security to the websites and making it impossible for hackers to hack it.


Always provide your clients with a solution they are satisfied with. That’s what all clients expect when they pay to get solutions from advertising agencies in Fort Collins, CO. Client satisfaction means a lot. A satisfied client will recommend you to people whenever he gets a chance but an unsatisfied client won’t. The more satisfied clients you have the more will grow your reputation and popularity and the more you will get new work.


Again it is really important for freelancers to manage their time. It is easy to manage your time. You just need to set the time you will work for and time for other things.
To manage my time i write everything i need to do in my diary and then check mark the things i complete. It is a good idea to use a diary. Try it 🙂



By saying filling up your toolbox i mean filling up your computer with the required softwares. By software i don’t mean paid and commercial softwares. As you are just starting up you need to use tools which are either free or the ones you have actually paid for. Once you start your carrier as a freelance web designer/developer you cannot use the tools downloaded from the torrent sites and all other websites. Its the time to either use free tools or pay for the commercial tools if you like them. Freeware tools do not mean that they are waste just because they are free. For example, GIMP is a free alternative of Photoshop. GIMP lacks some functionality that Photoshop includes but it is not a waste. GIMP is a really amazing software you must try.


It is a really good idea to build up new relationships with other freelancers. This can help you get more projects in many ways.
For Example, A freelance web designer you know gets a new project on developing a wordpress theme and he is not good at it. But he knows that you are good at developing wordpress themes will give the project. And when you get a project that you are not capable of doing you can give it to the other freelancers you know.

Before taking a new project you should consider these things:


This is the most important thing to consider before taking a new project. Before taking a new project check out the skills needed to complete the project. Never take a project unless you are good at doing the task.
For example, if you find a new project titled ‘SEO Expert Needed’ then you should only apply for it if you have the skills needed and are good at it.
I have one more example for you. Let’s assume that you have found a new web design project that requires four skills namely, Bootstrap, JavaScript, HTML, And CSS. Then you should only apply if you are good at all the four. Never apply for a project that you are not capable of completing. Or you might get in a big problem.


Always ask yourself this question before taking a new project. This is the second most important thing to consider. If you have the required skills for a project but don’t have the time needed to complete it consider not to apply for it.
I simply mean you should check if you really have the time for completing the project. You should only take a new project if you have the required time.
For Example, If you find a new project requiring a PHP developer who can integrate Facebook oAuth login with a website. If you have the skills but don’t have the time. Never apply for new projects.


By saying this i simply mean that you should state all your terms and conditions of work to the client. It is a good idea to state things like charges for future changes and customization after project completion. I always state all my working terms to the clients like how i will charge them on fixed or hourly basis. Not stating all your terms will get you in problems in the future.


State all your charges in detail to the client. For example, If you are charging $500 for web app development. Don’t just tell your client that you are charging $500 for web application development. Be clear and tell your client how much you are charging for different components of the web application. If you are charging $100 for admin dashboard, $150 for a forum, $200 for jobs board and $50 for coffee :D. State it clearly.

After completing a project:


Always ask your clients for feedback after completing a project. Getting client feedback will not only help you improve yourself but will also make a good image of yours in the clients eye. You can also show the client feedback in your portfolio websites in a testimonials section.
When asking clients for feedback, I myself send them an email asking them to reply with their feedback.


Don’t be selfish after completing a project and receiving the payment. Be a good guy and Stay in touch with your clients. Staying in touch with your old clients can bring you more work opportunities. And it is a good habit to keep in touch with your clients. Staying in touch will help your clients remember you and if anyone asks them for a web designer/developer they know they will tell your name.

PHP is much better than you think

Rants about PHP are everywhere, and they even come from smart guys. When Jeff Atwood wrote yet another rant about PHP, it made me think about the good parts of PHP.

PHP is much better than you think

The biggest problem of these rants is that they come from people stuck in the old days of PHP. They either don’t care or they don’t want to admit that PHP actually evolves at a very fast pace, both at the language level but also at the community level. In fact, it evolves much faster than any other language or web platform. It has not always been the case, but the last 5 years have been an amazing journey for PHP.

Before talking about the amazing things the PHP community has achieved recently, let’s have a look at some interesting numbers: PHP is used by 77.9% of all the websites whose server-side programming language is known. WordPress is used by 16.6% of all the websites in the world. If you have a look at the top three CMSes, for the websites that use a monitored content management system: WordPress is first with 54.3%, Joomla is second with 9.2%, and Drupal is third with 6.8%. Three products written in PHP.

PHP must have done something right, no?

Now, let me tell you a secret, the PHP “tour de force”: Despite the changes over the years, PHP is still the easiest language to learn for non-technical people: it allows anyone to create dynamic websites faster than with any other technologies, it allows anyone to host websites cheaply and without any hassles. PHP is probably not the best designed language in the world, but it lets you get things done, and you can’t argue with that.

PHP, the Language

PHP 5.0 (released in 2004) brought us a very solid object model… wait a minute, I’m talking about something released almost 8 years ago. Fast forward now. The latest PHP release, PHP 5.4, comes with all the bells and whistles you might dream of in a modern web language: yes, PHP supports namespaces; yes, PHP supports closures; yes, PHP supports traits.

It took some time, but PHP 5.4 also comes with some nice syntactic sugar that makes the whole experience better than ever: yes, PHP supports [] to define arrays; yes, PHP supports calling a method on a newly created object ((new Foo())->bar()); yes, PHP supports getting an array item from any expression ($foo->bar()[1]).

PHP has even learned from its mistakes: register_globals and magic_quotes are definitely gone.

Last, but not the least, PHP even comes with a built-in web server that eases local testing… and it starts in a matter of micro-seconds.

Next challenges: How do we “upgrade” all the old tutorials talking about PHP on the web? What is the best way to support the WebSocket technology in a PHP application?

PHP, the Ecosystem

Having a good language is great, but having a great ecosystem is even better. And the PHP ecosystem has evolved a lot in the last few years.


I won’t talk too much about this one. Git is everywhere and PHP embraced Git pretty fast. Almost all major PHP libraries, frameworks, and products are now using Git, including PHP itself.


Two years ago, I wanted to get rid of my ugly-PEAR-hack I did in symfony 1 to support plugins. I wanted to replace it with something that was able to manage project dependencies, not a global installer like PEAR. Managing dependencies is not an easy task, so I tried to find the best algorithm to manage software dependencies; I had a look at everything: from Perl to Ruby, from Debian to Redhat. Nothing was satisfactory: only homegrown solutions that happen to work… empirically. Then, I stumbled upon ZYpp. That was it. ZYpp uses a SAT solver to manage dependencies. Fast forward. Thanks to the hard work of Nils Adermann and Jordi Boggiano, PHP now has one of the best dependency manager, Composer.

Yes, PHP has a better dependency manager than any other languages.

And thanks to Git, Composer, and the PHP built-in web server, it has never been easier to download/install/test a PHP project.

Want to test Symfony (using PHP 5.4)?

1 $ composer.phar create-project symfony/framework-standard-edition
2 $ cd framework-standard-edition
3 $ ./app/console server:run

Want to test Silex?

1 $ composer.phar create-project fabpot/silex-skeleton
2 $ cd silex-skeleton
3 $ php -S localhost:8888 -t web/

Don’t know Composer yet? You should learn about it. Browse Packagist, the main Composer repository: it already has 1900+ packages available and they have been installed more than a million times in less than 3 months.

Next challenge: include the Composer installer in the next PHP version?


Community collaboration is the most important point of this post; the one I’m the most proud of. We start to see better collaboration between PHP projects, even from the very big ones, the ones you would think are large enough to not care about the others.

phpBB, Drupal, eZ Publish, Symfony, and many others (phpDocumentor, PHPUnit, Behat, Zikula, Propel, Doctrine, Midgard, …) are sharing code. Yes, they are “competitors” but they all understood that cross-pollination was a good thing. And Composer is a good enabler.

Next challenge: Convince even more projects to join the trend.


Let me say it again: PHP is probably not the best language out there, and I’m the first one to scream about its quirks, but PHP is the best web platform… ever.

Why use Php for make website?

Why use Php for make website?

At this time 30-40 % website developed in Php. It is open source i.e. everyone has free access to the source code and can use it for their own development purposes. Lots of advantage using PHP …….
1. Easy to learn in comparison of other technology.
2. 8 to 10 times faster than other technology.
3. It is highly secure. ex- Paypal (payment gateway) website.
4. PHP is html embedded.
5. Platform independent.
6. It offers great flexibility during and after the initial project.
7. Some well known website developed on PHP ex. Facebook, Wikipedia etc

Top 10 Sites to Receive SMS Online without a Phone

Top 10 Sites to Receive SMS Online without a Phone

It is very common nowadays that you will need to at least provide your email address in order to sign up for a service offered by a website or to participate in a discussion at a forum or even leaving a comment on a blog. If you don’t care about receiving a reply or are not comfortable in providing your real email address, there are many temporary disposable email addresses that can be automatically and instantly generated for use without any hassle. The only drawback is the temporary email address can be accessed by anyone if they know the username unless like Hide My Ass Anonymous Email that offers password protection feature for better security.

Receive SMS Online

Because of this, the email verification system is not secure at all. This is why some websites have implemented a phone verification system where the user needs to provide a phone number to receive a randomly generated code via SMS or voice call and feed the code back to the website to confirm that you are a real user and not a spam bot. The aim of phone verification is very similar to CAPTCHA for determining real users and preventing the same user from having multiple accounts except it is done through a phone number. If for some reason you need to receive text messages online from your computer rather than your phone, here are top 10 sites to help you receive SMS online and show the code to you.

Here’s an amazing article that can explain to you if is spybubble a good android spying app? This app has the option of recording everything a person does on their phone instead of using an app that only sends you the messages.

10. Twilio

Ironically, Twilio gives you a private phone number for free in the trial account if you provide them with your phone number to receive a verification code. Fortunately you can use any of the temporary phone numbers from the sites above to receive the verification code to activate Twilio trial account.

Twilio phone number

You can view your private phone number given by Twilio by clicking NUMBERS on the menubar on top of the page. To view the received SMS text message, click on LOGS followed by MESSAGES. Do note that the trial account of Twilio cannot send messages to unverified numbers but can receive SMS online from any phone numbers without problems.

Visit Twilio

9. Sellaite SMS RECEIVER

The country of the public phone number offered by Sellaite SMS RECEIVER to receive SMS online is Estonia, which is quite different from its competitors. We found that they are quite reliable because they are very quick to take down the phone number from the webpage if it doesn’t work. If you see a phone number available, it is very likely to work unless the SMS gateway can’t send a text message to Estonia.

Sellaite SMS Receiver

Simply click on the available online phone number on the webpage and the messages that the number has received will be shown.

Visit Sellaite SMS RECEIVER

8. Pinger Textfree Web

If you are having trouble signing up with TextNow because you can’t find a working US proxy or VPN, Pinger Textfree Web is a great alternative because anyone can sign up and use it for free. During sign up you will need to provide a valid US zip code (example 01001) which can be found by searching in Google. Then you are presented with a list of US phone numbers that you prefer to use.

Pinger Textfree Web

If you can’t remember the phone number that you’ve chosen, simple click on Options and your phone number is displayed at the first line when your account information pops up.

Visit Pinger Textfree Web

7. TextNow

TextNow is a good option if you’re looking for a reliable and free private phone number that only you have access to the received SMS text messages. You will need to sign up for a free account and you’ll be automatically given a unique phone number. The only common problem that most people get is receiving a generic error message “Something went wrong with your signup. Please try again!” when trying to sign up. To solve this problem, all you need to do is use a US based VPN or proxy to perform a one time sign up and you can login normally using your own IP address.


Your personal unique US phone number to receive SMS online is shown at Account Details after logging in.

Visit TextNow


2 weeks ago they had 7 phone numbers with only 1 from the US failing to receive our text message. Now they are showing 8 numbers but unfortunately none of them are working because their secondary domain name seems to be down which makes it impossible for us to check for received messages. We’ll test and update the results once they are back up.

Receive SMS Online



This site occasionally spurts out warning error messages on top of the webpage. You can safely ignore it and simply scroll down to click on any of the publicly listed phone numbers to view the received text messages.

There used to be 7 phone numbers on this site but it’s been reduced to 4 after 2 weeks. Only the US number failed to work while the Hungary phone number is the most reliable.



If you’ve visited the third site ( on this list, you’ll find that the design looks very similar except for the difference in color and that is because they are both created by the same company “Cicklow”.


2 weeks ago three US phones numbers are listed and none of them worked at that time. They have been replaced with 2 new phone numbers and are currently working.



Offers a total of 8 phone numbers with 3 from the UK and 5 from the US. Two weeks ago there were 7 numbers and an additional US number has been added to the list. After testing, 2 US phone numbers (+19282388889 and +19282388892) failed to receive the SMS test message that we sent.

Weirdly, the 2 numbers that failed to display the test SMS message sent by us showed that the last messages received were 12 and 21 minutes ago. So if you see a phone number that has recently received a message, it does not necessarily mean that it is fully working at the moment.


2. offers 10 public phone numbers from 8 different countries (US, Norway, Sweden, Australia, UK, Hungary, Spain and Lithuania). Although this site seems to be a winner, we did find that they are quite unreliable because 2 weeks ago only 3 out of 10 phone numbers received the test SMS that we sent and today it seems that they’ve fixed some of their numbers with 7 out of 10 working (1 Spain and 2 US did not work).


Only 1 US number was changed compared to the numbers listed on the website two weeks ago. is the only site that displays the sender’s full phone number while the others hide the last 4 numbers.


1. lists a total of 6 phone numbers, currently 3 from Great Britain and the other 3 from Sweden (previously was 4 Great Britain and 2 Sweden). Any messages sent to the public phone numbers will be instantly displayed on their website after a browser refresh unless you subscribe to their private phone numbers where you get a private inbox to view the messages. gets the top spot because all 6 public phone numbers are able to receive and display the test text messages that we sent.


Final Note: We used our personal paid account to send out SMS messages to the public phone numbers to test if they are able to receive the text. Even if some of them appear to be working, the phone numbers that are used to receive SMS online can still be easily blocked using TeleSign’s PhoneID that can identify the type of the provided telephone number such as VoiP, fixed land line, mobile and etc.

Hacking Firefox to Always Auto Save Password Without Showing Notification

Hacking Firefox to Always Auto Save Password Without Showing Notification

While I was screening through new posts in the forum to see if there are any spam and also any computer topics that I can help with, I saw an interesting question being asked. Is there any way to make Firefox auto save passwords without clicking the Remember button?. In Firefox, even if you have the option “Remember passwords for sites” checked in Tools > Options > Security, the browser will still ask the question “Would you like to remember the password for “Username” on” with three selections which are “Remember Password”, “Never Remember Password for This Site” and “Not Now”. The earlier version of Firefox 3 displays a notification bar at the top of the web browser, while from version 4 until the current version 21 displays a popup notification at the top left.

Disable Firefox Remember Never for This Site Not Now button

Modifying Firefox to auto save the login information to the Firefox Saved Passwords manager without prompting was easy for version 3 because you can directly edit the JS files from the program’s folder to apply the changes. However, the file structure was a bit different starting from Firefox 4 up to and including the current versions. We researched and found that it is still possible to force Firefox to auto save the password without the popup notification. This can turn Firefox into a keylogger and no antivirus will even detect this as a threat.

Steps to Hack Firefox 3 to Auto Save Password

For Firefox 3, all you need to do is edit the nsLoginManagerPrompter.js file with a text editor preferably Notepad++ located in C:Program FilesMozilla Firefox components folder. Search for the _showSaveLoginNotification function and replace the whole code that is highlighted in yellow…


With the following code:

var pwmgr = this._pwmgr;

The end result would look like the image below.

Firefox auto save password without notification bar

Save the changes that you’ve made on the nsLoginManagerPrompter.js file and whenever you login to any website, Firefox will auto save the site, username and password to the login manager WITHOUT showing the notification bar. You can access the saved password area by going to Tools > Options > Security and click the Saved Passwords button. There is one possible bug which is even when a user entered the wrong username or password, it will still be saved.

Download Firefox 3.6.28 | Download Modified nsLoginManagerPrompter.js

As for Firefox 4, it gets slightly difficult because the nsLoginManagerPrompter.js file is archived in an omni.jar file located at C:Program FilesMozilla Firefox folder. I’ve previously written a guide on how to edit files inside omni.jar file which would allow you to modify Firefox 4 to auto save password without prompting.

How do you import a large MS SQL .sql file

How do you import a large MS SQL .sql file?


Method 1: Bigdump

bigdump2 300x236 Here are three methods for importing large SQL files

I used a script called BigDump.php, a staggered SQL dump importer. It executes only a small part of the huge dump and restarts itself. The next session starts where the last was stopped to keep you from running into your server’s limits. Instructions for using it are on the BigDump website. Basically you place your SQL file in a folder on your server, along with the bigdump.php file. You edit that file with your database information and then visit the page on your server and set the import to go. This is a fairly quick process and will save you a lot of time.

Method 2: SSH

If you have root access to your server, create a backup using SSH

cd to the directory where you want to store your dump file:

cd /var/www/vhosts/

Then tell mysql to dump it out:

mysqldump –add-drop-table -u dbuser -p your_db > mybackup.sql

It will prompt you for your password. Everything should dump out without a problem.

*Note: The directory where you’re sending the dump file needs to be writeable by the server. Also, you don’t really want to leave it in that folder permanently. Just drop it there and pull it off your server so that you can manipulate it if you have to.
How to Import a Large SQL File

Importing is usually a bit messier. If you’re duplicating this database for testing purposes or moving your site to a new server, a large dump file, even when gzipped, can pose some challenges in the import process. This is the part where things can really stall out, and you need a few tricks up your sleeve.

Ordinarily I would just use phpMyAdmin to import the file. Because it’s so large, the first thing you should do is try importing via SSH:

mysql -u your_database -p db_user < mybackup.sql
Common Error when using SSH:

“got a packet bigger than ‘max_allowed_packet’ bytes”

Now what? Depending on the size of your file, running this command may fix it for you:

mysql> set global max_allowed_packet=1000000000;
mysql> set global net_buffer_length=1000000;

Then try importing your database after this. If it still doesn’t work, you might try splitting it up.

Method 3: splitting up your SQL file

Download a program that will split up your SQL file, such as SQLDumpSplitter2. This is a free SQL dump file splitter that will let you determine how big your chops will be and will automatically cut and save your split SQL file. Yes, this is a pain, but it is sometimes the only way to get this accomplished.

sqldumpsplitter2 Here are three methods for importing large SQL files

Create the splits and then upload them to a directory on your server.

If you want to restore the dump, you have to execute the yourdatabase_DataStructure.sql first because it contains the Tables structure. After that, you can execute the other .sql-files as they contain the data of the now existing tables. Using SSH, CD to your directory again and make sure to send this first:

mysql -u db_user -p db_name < yourbackup_DataStructure.sql

Then your splits:
mysql -u db_user -p db_name < yourbackup_1.sql
mysql -u db_user -p db_name < yourbackup_2.sql

Newsletter Subscribe

Get the Latest Posts & Articles in Your Email

We Promise Not to Send Spam:)