How to "Import SQL file to MySQL"

[youtube https://www.youtube.com/watch?v=T3A-wfqtjZA]

first, create the database

then select that database (use database_name)

then, use the following command

source sql_file_path(C://file.sql) then click enter

Thatsall

Comments

Post a Comment

Popular posts from this blog

Simple Mail Sending Contact Form using PHP and Jquery

here am sharing simple email sending contact us form source code using php and jquery, for this you need a PHP working environment with SMTP protocol enable and jQuery plugin here is the source for sending mail HTML CODE: [code language="html"] <div class="content col-md-5 wow fadeInDown" data-wow-duration="1000ms" data-wow-delay="300ms"> <form id="main-contact-form" class="contact-form mail_class" name="contact-form" method="post" action="email.php"> <div class="err_msg"></div> <div class="form-group"> <input type="text" class="form-control" name="first_name" id="Inputname" placeholder="Full Name" required=""> <label for="first_name"><i class="icon-tag"></i></label> <div class="clearfix"></div> ...
Read more

Codeigniter with Admin LTE

Admin LTE template with PHP Codeigniter 3.2.1 latest version integration Download the code from the repository. Unzip the zip file. Open browser; goto localhost/PHPMyAdmin. Import the file "db.sql" in that database. Copy the remaining code into your root directory Open browser; goto localhost/[project-folder-name] and press enter The login screen will appear. To login, I am going to provide the user email ids and password below. System Administrator Account: Email:  admin@bewithdhanu.in Password: 123456 Manager Account: Email:  manager@bewithdhanu.in Password: 123456 Employee Account Email:  employee@bewithdhanu.in Password: 123456 Once you logged in with System Administrator account, you can create a user or edit the previous user if you want. Dependencies NAME VERSION WEB REPO CodeIgniter 3.1.0 Website Github AdminLTE 2.3.5 Website Github Bootstrap 3.3.7 Website Github Ion Auth 2.6.0 Website Github jQuery 2.2.4 Website Github Font Awesome 4.6.3 Website Github Yo...
Read more

onclick anchor tag open url in bootstrap model

for example let us thisnk your anchor tag is [source language="html"] <a href="https://google.co.in/">Google</a> [/source] Now you need to open that link in bootstrap model,for this just follow this procedure write your anchor tag as make sure you already included jquery js file and bootstrap css file in this page HTML COde: [source language="html"] <span name='https://google.co.in/' class='mapview_link'>Google</span> <div class="modal fade in" id="RtPopupModal" role="dialog"> <div class="modal-dialog" id="RtPopupType"> <!-- Modal content--> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal">&times;</button> <h4 class="modal-title" id="rtpopuptitle"></h4> </div...
Read more