Navicat jobs

Hi there, I require a SQL Query (mysql) to be used in phpmyadmin or Navicat for SQL. The query is to produce a list of students and their earliest and latest dates for a given subject. The tables and required query result are attached. Please do not PM to have further discussion or ask questions, as this is pretty clear and easy. The successfully bidder will be based on skills, price and time to complete. Please submit your query for me to test. Do not big and expect me to hire you then see result since this is easy.

i want to change database type , postgres to mongdb, i think navicat is slower then mongdb and want to change database ,im not going milstone or award since i will check that everything work in my computer well ! i want this asap

I need a simple code to connect to mysql from VB6 (Only the connection and retriving information). I am using the code in the attachment and the driver attachment too, but have problems with some characters, specially "ñ". I try a lot of codes but don´t work. Using Navicat to connect show correct the characters, but from VB6 no.

I need to have a new Linux server configured that is running Ubuntu 20.04. We need the following software installed and configured: 1. Plesk Server Management 2. Odoo Community (using Postgre SQL) 3. Navicat for Postgre SQL 4. Create Wordpress Instance (not including any site development)

I have programe and for that i want to get best database programme like navicat

...migration work was terminated. Personally, I think the OS, PHP, MySQL and other environments of the new server to be migrated must be consistent with the original server. Otherwise, an error will occur during system operation, which will lead to failure to work normally on the new server. I migrated the web page code with the FTP tool, Mysql database is migrated through the data transmission method of Navicat premium tool. About the source Server: Server CPU : Intel(R) Xeon(R) CPU E3-1220 V2 @ 3.10GHz Server Memory : 4GB Server HardDisk ： 450GB Server OS : CentOS release 6.10 (Final) Apache: Apache/2.2.15 (Unix) Apache folder：home/awebser/server/httpd-2.2.22 PHP : PHP 5.6.19 (cli) (built: Sep 6 2020 13:19:37) MySQL : Ver 14.14 Distrib 5.1.63 MySQL DB Size: 30GB Web Source Fold...

...migration work was terminated. Personally, I think the OS, PHP, MySQL and other environments of the new server to be migrated must be consistent with the original server. Otherwise, an error will occur during system operation, which will lead to failure to work normally on the new server. I migrated the web page code with the FTP tool, Mysql database is migrated through the data transmission method of Navicat premium tool. About the source Server: Server CPU : Intel(R) Xeon(R) CPU E3-1220 V2 @ 3.10GHz Server Memory : 4GB Server HardDisk ： 450GB Server OS : CentOS release 6.10 (Final) Apache: Apache/2.2.15 (Unix) Apache folder：home/awebser/server/httpd-2.2.22 PHP : PHP 5.6.19 (cli) (built: Sep 6 2020 13:19:37) MySQL : Ver 14.14 Distrib 5.1.63 MySQL DB Size: 30GB Web Source Fold...

web admin console for xshell and navicat, support multiple users and roles

Work on mysql server on Navicat program

...visit the Theme Home Page Demo here: 2. Visit the development website with the theme installed Access for the developer: 1. You will grant access to the WordPress using Admin privilege account. 2. You will grant access to the FTP to upload/download files. 3. You will grant remote access to SQL DB using your favorite software (like Navicat, phpMyAdmin, Workbench or Dreamweaver). Please note: I will have to whitelist your IP to the DB, you will provide me your IP and only then you will have access to the DB server. 4. You don’t have access to the cPanel 5. You don’t have access to advance panel (e.g. DNS configuration, emails etc.) After reading all details, notes, attachments you think you’re can finish this project, send us your

I am experienced, but now retired programmer. I need some help in getting started with SQLite and Navicat for SQLite. This project might require, at most, an hour or two for someone with experience with both tools to walk me throught a single example of setup, configuration, and the importation of a CSV. Once we have the data imported, the correct data types set, and can run a couple of queries, I should be self sufficient from there and the consulting project will be completed.

I need you to write articles about MySQL. IMPORTANT: We need experience with cPanel and MySQL databases. We need you to install each of these applications: * phpMyAdmin * DBeaver * Squirrel SQL * Datagrip * Heidi SQL * MySQL workbench * Sequel Pro * Navicat * MySQL Front And then, write one *unique* article for each one, with printscreens of these functions: * A brief history about the application (DBeaver, Mysql Front, phpMyAdmin, etc...) * How to connect to MySQL (CONNECT) * How to select a database (USE) * Show contents (data) into a table (SELECT) * How to create a table (CREATE TABLE) * How to insert data in the table (INSERT) * How to update data (UPDATE) * How to delete data (DELETE)

I am using a Windows server with Navicat for the MySQL database and EasyPHP for connecting to the MySQL database. I have a Delphi 7 chat program that is supposed to connect to the server via the server IP. I had this all working perfectly fine until I changed servers and now I don't know why it won't connect. I turned off the Firewall and allowed the EasyPHP and program's server .exe in the firewall but neither solved the issue.

I am using a Windows server with Navicat for the MySQL database and EasyPHP for connecting to the MySQL database. I have a Delphi 7 chat program that is supposed to connect to the server via the server IP. I had this all working perfectly fine until I changed servers and now I don't know why it won't connect. I turned off the Firewall and allowed the EasyPHP and program's server .exe in the firewall but neither solved the issue.

Need help to create a query for Postgres to know the number of products on hand, need the internal code, name of the product and the qty on the stock. Using Odoo version 10 and Navicat as query builder. I need a Teamviewer or AnyDesk, so we build the query on my computer. I believe is an easy task for someone who knows the Odoo tables, therefore, my budget is $25 for this project

Necesito que se configure un servidor web con Centoes para que pueda aceptar conexiones a la base de datos desde Navicat De preferencia que el freelancer hable español

I have the database available in Postgres and i want to convert Postgres DB into Mysql but i want DB Schema from you. Anyone who is expert in that , contact me! I will provide you Login details of current DB. You can use Navicat or Mysql WORKBENCH and you can create the report from there and map the relationships.

We need solution for Centralized DB. Its a 15 min job for database expert but I will pay minimum 2 hours pay if you can do it just because of urgency. You have to guide our developer on skype. We have DB in one Hosting server (A...pay if you can do it just because of urgency. You have to guide our developer on skype. We have DB in one Hosting server (Azure Redhat virtual server) and we need to use the same db in other hosting server too. So it will be centralized DB for both server. I can not use it in navicat also if I use IP of Mysql DB. I have tried using ( bind-address= IP address of the server where db is hosted ) in file but it doesn't allow remote access. to use it in other hosting server nor in any mysql client like navicat / Heidi sql. No time w...

Please refer to I would like someone to write a php scrip with the following input: ID, PMID 1, 24329979 2, 24329978 3, 24329977 4, 24329976 5... Here is an example input 24329979 The output i need is RCR and total citations For this example, it is 1.39 and 7. The finished project will include: loading a new database in navicat on my computer uploading all files and folders to run scrip Project is complete when I am shown how to run the script on my computer The ability to run a report with up to 1,000,000 PMIDs.

I have a project running on a vagrant virtual Linux box. The project is using a postgres db on this VB. I am having an issue connecting to this db on Navicat. I need someone who knows how to configure vagrant VB so that I can connect on my Navicat. I need to configure port forwarding on vagrant. I can only let you see my screen [The administrator removed this message for encouraging communication outside Freelancer.com, which breaches our Terms and Conditions - Section 13: Communication With Other Users.]. We will have to go through this together.

Hi AlxKS, I noticed your profile and would like to offer you my project. We can discuss any details over chat. I just need to setup an Amazon AWS RDS Database and connect to it from MySQL Workbench, Navicat, and a sample php connect page. I'm just trying to lay the foundation for a quick db for my internal use.

Need to giving full privileges to MySQL user ‘userhandsome’ in order to be able to Export/Import data using MySQL Workbench / Navicat or any other application remotely. Currently user ‘userhandsome’ has not permission to view table ‘user’ which is needed in order to complete data export or import. Also to be creaated f a MySQL user that has the ‘GRANT ALL’ permissions so that it can be used for Import/Export of data using third part application other than Plesk. Need to be done the same set up in 2 servers by transfer the database from A server to B server Also need to be get written instruactions how this can be done.

I am not able to import my csv format file to database. Navicat gives me an error. It gives me errors like this: [Msg] [Imp] Import table [proxies] [Err] [Row1] [Imp] 1062 - Duplicate entry '' for key 'ip' [Err] [Row1] [Imp] INSERT INTO `proxies` (`ip`,`port`,`version`,`region`) VALUES ('','9007','SOCKS5','EU-London'),('','31477','SOCKS5','EU-London'), Please help me solve this error. Thanks.

I am not able to import my csv format file to database. Navicat gives me an error. Please help me solve this error.

Here's an example of a web page I need to scrape certain data from: So, it will always be such a Twitter list where the list members are in one big list. (not the entire list is shown initially, you have to keep scrolling d...is the ID and I need the scraper to get that data for all list members along with the other data points. To get the bio search for <p class="bio ">. Inside that paragraph is the bio I need. The scraper script can be bare-bones, no interface needed. However, you must provide me clear instructions that will allow me to run the script on my own. (I have XAMPP installed as well as Eclipse and Navicat) I'm willing to pay up to $30 and you can be sure to get a 5-star rating and a positive review from me.

I am looking for a freelancer that will configure my webserver. Y This is going to be a lemp server and it will be REQUIRED to have the following installed. 1. Centos7 (done by linode) 2. NGINX 3. MARIADB (create a User for LARAVEL, as well as create me a remote connect user that has ability to create new users and assign them via NAVICAT) 4. FTP and SFTP 5. php-fpm (AT LEAST 5.6... I would preffer php-7 but I do not know about LARAVEL 5.1 & php-7) 7. LARAVEL 5.1 (I will say again 5.1) I will provide you with SSH, I will provide you with the users that are to be created. Other notes: Two different users will be created... 1 for my SSH, 2. for FTP. I will provide the passwords and usernames for both. ROOT LOGIN NEEDS TO LOGIN PERMISSIONS DISABLED. If you have a...

...campaigns adding any Sender ID, and message text he likes. All the testing will be done by the freelancer and when the freelance will be able to send email campaigns successfully using the script then will inform me to make a test if everything is working as per my request and the freelancer will get immediately paid. I can give you FTP access and database access (you will need a software like Navicat or any other software you like to connect on the database server) on the server that the script is hosted, ( I cannot give you cpanel or SSH access) and also I can give you full Script Admin Control Panel access, but have in mind that I will not be able to help you at all, so any help you may need you have to contact either cs-network or UltraSMSScript. As for you have to creat...

PHP, MYSQL, NAVICAT I need to have a form pull information from a database that allows QCs to check off options and save the form as a QCRPT#XXX that is later searchable by admin. The deficiencies in the QC report will be tallied and a create a PAYADJUSTRPT for manufacturing line A,B,C, etc.

A wordpress website will be manually moved from a subdomain to it's new address. Source installation has phpmyadmin access, target installation has not, navicat etc can be used for target mysql server.

Need a simple script written, that can execute a pre-written task (which has already been created) if certain errors come up in WINSCP / NAVICAT MY SQL

I have an existing PHP program to extract data from NCBI. I would like to increase the number of extracted fields by updating the PHP program and change the tables in SQL (I'm currently using Navicat). I would like this work to be done on my computer and instructed how to execute the program to confirm it is working properly. I can provide the current PHP program to review before the project starts. Current Program Fields (Input) ID Number keywords Output ID number Keywords email address I would like to include: Pubmed ID Authors 1,2,3,4,5,6,7,8,9,10 Author Organization ID Organization 1,2,3,4,5 Abstract Title First 200 characters of the abstract

Hi, I want to start my new project based on habbo, a 2d flash game where you can create your alter ego in a virtual world and make a new friends, play and chat whit other habbos. I already have file, but have a problem whit it. CMS is based on php and now running on localhost with IIS and the database is managed with navicat. I can buy a VPS to start work, resolve CMS problems and modify something in index page.

I bought a website and I n...like the website is a wordpress website. Its php. Its linux. The zip is the entire directory from another host. I only want installed what I need for one of the sites to run. Will also need an mysql db. Scripts are in the zip. I don't want to have to do anything. I can give you ftp access to the directory at go daddy and I can try to get an account setup for (I think its phpmyadmin (Navicat maybe?) or something. I am a .net dev and have not used mysql or php in years.) In your proposal, tell me what you will need (That you know of for sure. I can provide further things later.). If I do not get a proposal that comforts me (Knowledge, not price), I wont award it. Chance of other websites later since I like to buy sites I dont know how...

We currently use Navicat Premium (Navicat Premium is a database administration tool that allows you to simultaneously connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application) and have created a linked SQL Server to be able to sync, manage and pass content from Quickbase tables to MySQL (wordpress) DB’s that are hosted remotely at Bluehost. The program also allows information to be passed into Quickbase using SQL (access allowed via QuNect). We are attempting to sync existing SQL and MySQL tables in quickbase via SQL using the QuNect procedure found below. We need the procedure properly edited to work for our needs.

I have a table that I need to add data to but every time I try to import it I get an error. Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp colum or insert a Default into the timestamp column. If I remove the column I get a error that the column cannot be null. We have Navicat Installed to import csv file but same error. Need someone who can remote to our server and figure out what we need to do to get this to work.

...what i need : 1)a Site close to this one : with some differrences 2)Account Creator With Email Confirmation 3)for the Header i need Special image close to this One But For Other Game. 4)in the centre at The Top we Gonna have some images a bit larger of this site i from images we Gonna have Youtube Videos With Title Comments And Rank on Video.i want via navicat or any other simple program like this to change every day the videos and images from from html code. 5)left and right from centre images-(6-7Youtube Videos)we gonna have Images of Social medias Like Facebook Channel Youtube from this two we gonna have 12 ads place and user if ad is free can rent the ad and choose for how much days want to rent x the moneys we gonna set(7$

I have a MySQL database on my Windows laptop. I use it only to manage some very large lists of contacts. The vendor who set this up installed Navicat for me, but it was a trial and has expired. I don't want to spend $400 on the software. Please help me find another method to manage my data. Mostly I just run queries and do exports of the data that matches my queries. I am not a programmer but I am an intermediate computer user.

My admin account on Navi went down today. My top admin added me with another account and gave full privileges to me. I logged on to find I had no privilege. I then used Putty to start up the related game server and now I cannot even log on to Navi.

I need an experienced programmer with Google Cloud SQL ( ) to help dump and import 2 MYSQL databases from my Windows server 2008 to Google Cloud SQL and have extensive experience with MYSQL. I have tried to generate a sql dump files for the databases using Navicat database client but am not sure if this dump file will work as I haven't tried it before. I already have the Google Cloud SQL activated on my Google Developers Console but I need assistance in creating the databases sql dump files correctly to ensure a smooth migration as detailed in the link below: Access to the Google Developers Console will be provided to the successful bidder. Please only bid if you have experience with

Continuing to work. I need Navicat support or an alternative.

I have an android based chat room app that runs off of WAMP server and is made in java. I have a database I use and currently the way things work is I connect to my server and then I open Navicat Application and I connect to the database and from there I make the changes that I need to make. The Only Places That I Need To Make Changes in The Database Are In 4 Tables accounts - Account Information for each user - Username, Password, Color, Date Joined, Permissions, Last Login, Last Ban, Device ID, IP ban_list - ID, Device, Reason, Expire,Expired block_list - Blocker, Blocked (This is simply used to keep track of what user has blocked another user by ID number) rooms - ID, Name, Password, type, order Within these tables are functions that I want to connect to a UI...

Hello... You have to make a chart for my database. I will give you every details and you only need to perform the task. You will need Navicat software for this. If you dont have this i will provide. charts will be collected based on written query .there should be 4 bars devided into 12 month . each bar on each month will be calculated cumulatively based on field dates for each bar .in each month there should be 4 bars to be displayed which is total amounts of some fields in the tables of my sql . Please bid only if you can do it. Please do not bid if you cant do it. For more info PM me.

...FTP login to our hosting/server 4. You will then design the site, build/code the site and upload and test on our server using text placeholders where the text will go. 5. We will supply new text for the site and you will upload 6. There will be an interactive form (to capture new customers) that will be saved to a database which you will also be required to create as part of the job. 7. Navicat or something similar will be used by the site owners to access the saved data. 8. SSL certificates will also be setup on the hosting server (all data from the forms sent back to a DB securely). 9. Some of the customer data capture form will be pre-populated from the same database (we will directly email potential clients with unique ID's in the email with links to the sign...

...with CI is necessary. The code is a little messy but it's nothing too horrible. We are using Mercurial for source control so knowledge of this is also important. Must haves: Skills -PHP5,MySQL,Ajax,jQuery,Javascript,HTML5,CSS3,XML -PHP Framework Codeigniter -PHP-CMS WordPress,Joomla -WEB Server:LAMP,WAMP,MAMP,EasyPHP,VertrigoServ -Tools / Software:Notepad++,Dreamweaver,MySQL Navicat -Web services:WSDL,SOAP -FaB development:Open Graph,Like Button,FaB Share,Graph API,Like Box,Like Button,Comments, Activity Feed,Live Stream,Facebook for Websites -Web Hosting :IIS,Apche,CGI,Domain,DNS,EMail,FTP,SSL,SSH,logs -OOPS PHP development -Hands on experience in Coding,Testing,Implementation/Maintenance Support in PHP and MySQL -Integration Ability: Strong...

WE NEED A PREDICTIVE DIALER / DATA MANAGEMENT GURU! In search ...PREDICTIVE DIALER / DATA MANAGEMENT GURU! In search of a Database Administrator to help manage our outbound telemarketing campaign. The Freelancer must have previous knowledge of working hands on with predictive dialers, extensive knowledge of data management and prove themselves by increasing overall lead generation volume. Knowledge of SQL and the ability to table data is a must! Experience with Navicat is also a plus! This position for is per job or hours spent working on our dialing campaign. Posistion can become long term and have the ability to even partner with the company if the performance is there.. COME PROVE YOUR STUFF! IF YOU ARE THAT DIALER / TELEMARKETING GURU WE ARE LOOKING FOR THEN CALL...

WE NEED A PREDICTIVE DIALER / DATA MANAGEMENT GURU! In search ...PREDICTIVE DIALER / DATA MANAGEMENT GURU! In search of a Database Administrator to help manage our outbound telemarketing campaign. The Freelancer must have previous knowledge of working hands on with predictive dialers, extensive knowledge of data management and prove themselves by increasing overall lead generation volume. Knowledge of SQL and the ability to table data is a must! Experience with Navicat is also a plus! This position for is per job or hours spent working on our dialing campaign. Posistion can become long term and have the ability to even partner with the company if the performance is there.. COME PROVE YOUR STUFF! IF YOU ARE THAT DIALER / TELEMARKETING GURU WE ARE LOOKING FOR THEN CALL...

Hello, I want to be able to run a php query and have the results be output in a csv format. I need you to write a curl script that will crawl info and gather th...org info and gather the following. ie: Search title only [1995 honda accord] Results [city],[state],[price],[listing title],[main img url],[link to listing],[date listed] I want it to search all of the US cities/states It will only search the cta section for cars for sale. I will provide you with access to the ftp and db, the db access is not myphpadmin but you will have to use navicat or similar. The data needs to be stored in the db once the query is run, I am going to run it once a day. Please let me know if you have any questions. PLEASE DO NOT BID IF YOU ARE NOT CLEAR ON THE ABOVE

Need a page where the user can enter a date select "Morning, Afternoon or All Day" and enter data into 3-4 text fields. This would get stored in a data table along with their user id. Need a page where they can display back all the records that correspond with their user id. ...data into 3-4 text fields. This would get stored in a data table along with their user id. Need a page where they can display back all the records that correspond with their user id. This would include a couple extra fields that were not part of what the user submitted but are a part of that record. These extra fields are updated manually by admin. No interface necessary, I can use Navicat or something similar to edit these fields. This should work with a standard wordpress us...

Ive got a linux server running whm on cent os. The sql service has packed in. just stopped this morning under light load. I can access all the databases through navicat and mysql but the server will bot deliver any mysql data over http. Server is also showing a load of 6 even though it shouldn't be doing anything much. Need it fixing, quick. Already had 2 people fail to fix this, please only genuine experts.

Ive got a linux server running whm on cent os. The sql service has packed in. just stopped this morning under light load. I can access all the databases through navicat and mysql but the server will bot deliver any mysql data over http. Server is also showing a load of 6 even though it shouldn't be doing anything much. Need it fixing, quick